Converting Date/Time to just Date Format for Query Selecting

[mhubbard]

I am having trouble selecting Date() from a field that also has time in it. Is there anyway to use the date function (or similar) to accomplish this select?
Thanks!

 

[Newman]

I'm not sure I truly understood your request, but I'll take a chance...
You could convert Date/Time to Date by converting it with CInt which takes the decimals away (as the time is a fraction of a day) and then converting it again with CDate.
There may be a better way, but this one works well.

 

[ColinEssex]

If you use Now() it includes the current date and time.

Col

 

[mhubbard]

Thank You!!! By Converting the Date/Time, I was able to select by date()