Pulling Data with Now() time function

[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

 

[John Vinson]

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())

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.