Query Dates, Access
This article will explain how to run queries on dates in an access database.
3 fields with the second field storing dates.
Selecting the Right Datatype:
It is essential that dates are stored in a field with the “Date” datatype. Storing dates in fields with other data types may result in errors:
The following Criteria was used:
The function DateSerial receives as input 3 values. A year, month and day. It returns a date value which can be used to compare against the dates in the database.
The Criterion below was used to filter the dates:
The number signs are automatically added by access. They specify that the value between them is a date.
You can download the sample file for this article from the link below: