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)?