Sort by time only in a date/time field

[ERB]

I have a column/field named [DateTaken] which contains test dates and times in the same cell. I am needing to find those with a test time less than 2:30 pm or <14:30pm.



data looks like this:

8/22/13 4:23 PM

1/29/14 12:21 PM

1/28/14 3:27 PM

8/26/13 4:27 PM

8/26/13 4:42 PM

1/23/14 1:58 PM

8/21/13 1:12 PM

8/21/13 2:40 PM

1/23/14 3:16 PM

this is what I have come up with to extract the time component of data set so that I can then later, sort it by the time in a query.

JustTime: TimeValue([YourField])

JustTime: ("hh:mm",([DateTaken])) and or ("hh:mm",[DateTaken])

I get either invalid operator or invalid syntax errors trying both of these.

Any help or ideas appreciated, Thank you.

[pbaldy]

The second one completely invalid. The first should work. Did you try

JustTime: TimeValue([DateTaken])

If that doesn't work, what's the data type of that field? Does it contain any Null values?

[ERB]

I just tried this TimeTaken: "h:mm"([DateTaken] and i get an error which I have taken a screenshot of, see below.

The date type of the field is date/time and it is in this format : m/d/yyyy h:nn


Also there are no Nulls in the data.

[pbaldy]

That's the second format that I mentioned was completely invalid. Did you try what I suggested?

[ERB]

I see now. I though that TimeValue meant that I had to input a number value or formula in order to get it to work. Its working now. Thanks for your help pbaldy.

[pbaldy]

No problemo!