Querying a Date/Time field on DATE only

[Lyconal]

Hi,

Anybody know how to do this?

I have tried converting the date on the fly, but to no avail.

Any help is appreciated.

Cheers

 

[Brianwarnock]

Datevalue will extract the date from a date/time field

Brian

 

[Lyconal]

Cheers for that.

Was pulling my hair out trying to use CONVERT (like I would normally in SQL2000)

Cheers very much

 

[Brianwarnock]

Happy to help, not confused by too much knowledge!

Brian