Date/Time - need to remove time portion

  • Thread starter Thread starter Cathi
  • Start date Start date
C

Cathi

I have a linked table that displays a Date/Time stamp; i
need to query records only on the date, as the time will
never be the same for any given month, how do I bypass the
time portion of that field in order to run the query?
 
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

dates in queries 3
How get rid of time portion of dates? 11
Select time only from a date/time field 8
Chg "day" portion of DateAdd Date 3
Divide Date Time Stamp 5
Date Function in query 3
Time() - 5 minutes 2
Trim Time off Date 4

Back
Top