Query on Date/Time field

U

Ugis Sulcs

How do I create the query to select the data from table for given time
interval (results from every day records between 13:00 and 14:00).
Field Format: Date/Time field- dd.mm.yyyy. hh:mm:ss
Records: 01.04.2001. 10:57:01;
15.05.2001. 13:48:22;
15.05.2001. 12:05:00
18.03.2002. 13:30:25
Results: I should select the results "date whatever" and time in the
interval <=13:00:00 and >=14:00:00, i.e.
15.05.2001. 13:48:22 and 18.03.2002. 13:30:25
 
S

Steve Schapel

Ugis,

Make a calculated field in the query, using the TimeValue function,
like this...
MyTime: TimeValue([MyDateTimeField])
.... and in the criteria of this column, enter...
Between #13:00# And #14:00#

- Steve Schapel, Microsoft Access MVP
 

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

Problem formatting dates from CSV file 2
date and time query 6
Checking for date and time overlaps 0
Date and Time 1
Issue with OLE DB Query - Date Search 0
Punch time query to calculate total work time 5
Date query problem 6
15 minute data to daily data 1

Top