Querying on a date field

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

I have a parameter query that looks at a date field. The
date field is set to a format of "general date" because we
need to track the time it was logged. However, when I run
the query and enter a date range, it assumes the last date
has a time stamp or 0:00:00 so it does not include that
date.

For example entering a date range of 01/01/04 to 02/01/04
gives me date entered through 01/31/04.

How can I change this to include 02/01/04.

Thank you,
Grace
 
I have a parameter query that looks at a date field. The
date field is set to a format of "general date" because we
need to track the time it was logged. However, when I run
the query and enter a date range, it assumes the last date
has a time stamp or 0:00:00 so it does not include that
date.

For example entering a date range of 01/01/04 to 02/01/04
gives me date entered through 01/31/04.

How can I change this to include 02/01/04.

Thank you,
Grace
Click to expand...

Grace,
Don't use any criteria in the [DateField].
Instead, add a new column to the query:
Exp:Int([DateField])

As criteria for this field, write:
Between [Enter From Date] And [Enter End Date]

If you enter an End Date of 3/1/2004, all records thru 3/1/2004
23:59:59 will be returned.
 
Back
Top