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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to find records after specific date and time today 10
Pivot table macro filter data between yesterday and today (date+time) 0
timestamp handle 5
Dcount returning no results!!! 0
Extract just the date from Date Time 4
Date Timestamp 1
I need specific date AND time help - please help! 2
Date/Time criteria problem 2

Back
Top