Date and Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top