Newbie: date-time help

[steve]

Hi,
I have created a date_time field that, as the name suggests, contains both
day and time info (02-03-2002 12:00:32)

How can i query both the time and day?
i tried :
......
WHERE
date_time > "12-02-98 00:02:23" and doesnt seem to work.

TIA
-steve

 

[PC Datasheet]

Date and Time are delineated with "#":
WHERE date_time > #12-02-98 00:02:23#

 

[John Vinson]

Hi,
I have created a date_time field that, as the name suggests, contains both
day and time info (02-03-2002 12:00:32)

How can i query both the time and day?
i tried :
.....
WHERE
date_time > "12-02-98 00:02:23" and doesnt seem to work.

Use # as a delimiter instead of ". Note that Access assumes that the
date portion is in American format, month-day-year - as written (with
the change in delimiter) this search should find all records with a
date_time value more recent than December 2, 1998 at 2:23 in the
morning.

John W. Vinson[MVP]