Pulling Data with Now() time function

  • Thread starter Thread starter Carlos
  • Start date Start date
C

Carlos

Hello,

I have a date field with the default now() that displays a
date of 08/12/03 12:34am.

What syntax would I use to pull any records that were
entered today? I dont know the proper syntax to specify
12:00am to 11:59 pm


Thanks in Advance
 
Hello,

I have a date field with the default now() that displays a
date of 08/12/03 12:34am.

What syntax would I use to pull any records that were
entered today? I dont know the proper syntax to specify
12:00am to 11:59 pm
Try:

= Date() AND < DateAdd("d", 1, Date())
Click to expand...

Date() returns just the date portion, 8/12/03 00:00:00; this criterion
will find all values starting at that midnight hour and running up to
a fraction of a microsecond before midnight on the 13th.
 
Back
Top