Newbie: date-time help

  • Thread starter Thread starter steve
  • Start date Start date
S

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
 
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]
 
Back
Top