M
MorrganMail
Hi,
I am trying to make a query that returns all records within a specific
time interval. The query targets a Date field containing only a time
i.e. #12/30/1899 TIME#.
WHERE
T.Time Between #06:00:00# And #06:00:00#
=> 0 records
WHERE
T.Time = #06:00:00#
=> 0 records
WHERE
TimeValue(T.Time) Between #06:00:00# And #06:00:00#
=> 1 record #12/30/1899 06:00:00#
Anyone who knows why the first two doesnt work? For me it seems like
there is something fishy about the date part which seems to be !=
12/30/1899.
I am trying to make a query that returns all records within a specific
time interval. The query targets a Date field containing only a time
i.e. #12/30/1899 TIME#.
WHERE
T.Time Between #06:00:00# And #06:00:00#
=> 0 records
WHERE
T.Time = #06:00:00#
=> 0 records
WHERE
TimeValue(T.Time) Between #06:00:00# And #06:00:00#
=> 1 record #12/30/1899 06:00:00#
Anyone who knows why the first two doesnt work? For me it seems like
there is something fishy about the date part which seems to be !=
12/30/1899.