Date and Time

D

Derek Wittman

Good morning
I have a timestamp in a table that I want to run a query on. My criteria is that I want to filter records for today - anything after midnight. I thought that Date() would work, but it doesn't seem to against a long format time/date

Can someone help, please
Derek
 
D

Derek Wittman

Please disregard. Just a few more minutes and I found the answer in the DateValue function

Thanks
Dere

----- Derek Wittman wrote: ----

Good morning
I have a timestamp in a table that I want to run a query on. My criteria is that I want to filter records for today - anything after midnight. I thought that Date() would work, but it doesn't seem to against a long format time/date

Can someone help, please
Derek
 
Top