Query to extract time only from date/time fields

[Archer]

Hi all.

Tried to find an answer to this one via the advanced search but came up empty handed. I want to extract records from a table based on time values only, i.e. >=12:00 and <=18:00 from a date/time field stored as dd/mm/yyyy hh:nn.



Can anyone advise please?

thanks in advance.

[pbaldy]

Check out the TimeValue() function.

[Micron]

Maybe
DatePart("h",[someDate])>=8 And DatePart("h",[someDate])<=18

[Archer]

Check out the TimeValue() function.

Yes i've used that which provides a new column that returns only time values, however when I try to enter criteria >="12:00" And <="18:00" the query is only returning values starting with 12:. Is my syntax criteria incorrect?

[Archer]

Maybe
DatePart("h",[someDate])>=8 And DatePart("h",[someDate])<=18

That worked nicely.
Thankyou

[pbaldy]

Yes i've used that which provides a new column that returns only time values, however when I try to enter criteria >="12:00" And <="18:00" the query is only returning values starting with 12:. Is my syntax criteria incorrect?

The delimiter for date/time values is #, not ".

[Micron]

UR welcome. Did you try Paul's suggestion with #?