So what is the correct query in your origninal question to correctly compare the datetime field with the 2 date fields? In other words how does one truncate the...