Darren,

Use the DATEDIFF function:

SELECT DATEDIFF(day, MyFirstDate, MySecondDate)

If it returns a zero, they're the same day.

~~Bonnie




>My biggest beef in SQL Server is the lack of Date fields (without time).
>I am forever having to compare dates from '00:00' to '23:59' when the time is absolutely irrelavent.
>I thought of using a character field to store dates but then the date functions are more complicated and there is no date checking...
>Anyway, your comments are welcome.
>For now, can someone tell me the easiest way to compare a datetime field with multiple times throughout the day to a single date (any time of day)?