>Hi all,
>
>How does one get the 'date" from a SQL server "DateTime" expression. If the answer is "you don't", then how does one go about doing date comparisons in searches?
>
>For example ... if I have a field called "OrderDate" that is filled with GetDate(), it is going to have something like "05/01/99 10:24:36:345 AM" stored in it. Now, how can I construct my where clause to find all records with an order date of "05/01/99" ? Obviously a search for "OrderDate = "05/01/99" wouldn't work because of the time portion of the value.
>
>Thanks!
>Ken

This may be a little late and I don't know how far you've gone but this is what I do:

SELECT * FROM AFile where OrderDATE >= "05/01/1999 00:00:00" and _
OrderDate <= "05/01/1999 23:59:59"

Hope this helps...

Ramon Carlos