>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)?
In the chance that you are using VFP then the following code will work.
Local ldDate, ldDateTime
* Date to Date Time
ldDate = Thisform.txtDate.Value
ldDate = CTOD(ldDate)
ldDateTime = DTOT(ldDate+1) - 1
Tom