Trying to subtract date range using General Date format

[Guest]

I know there's a way to input a short date format (i.e. 11/30/05) in a query
on a field that is formatted as general date (has time included).

The query is simple - it reads: >=[Enter Beginning Date] and <=[Enter Ending
Date]. The field name is: ActionDate.

I tried formatting the query field to short date, but unless I type
"11/30/05 00:00:00" and "11/30/05 23:59:59", I can't get all the records
for the date of 11/30/05.

help...what am I missing?
Thanks,
Connie

 

[Marshall Barton]

I know there's a way to input a short date format (i.e. 11/30/05) in a query
on a field that is formatted as general date (has time included).

The query is simple - it reads: >=[Enter Beginning Date] and <=[Enter Ending
Date]. The field name is: ActionDate.

I tried formatting the query field to short date, but unless I type
"11/30/05 00:00:00" and "11/30/05 23:59:59", I can't get all the records
for the date of 11/30/05.

That's because 11/30/05 (defaults to midnight) is earlier
that 11/30/05 1:15:00.

I think the easiest way to deal with this is to use:

=[Enter Beginning Date] and <[Enter Ending Date] + 1