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.