Criteria using expressions that calculate or manipulate dates
Expression |
4 Description |
Between #2002-05-27# And #2003-05-28# |
Uses the Between…And operator to display records where the field’s value is no earlier than 2002-05-27 and no later than 2003-05-28. |
#2003-05-28# |
Displays records where the field’s value is 2003-05-28. |
#2003-05-28 18:31:59.22# |
Displays records where the field’s value is 2003-05-28 at 18:31:59.22. |
Between Date( ) And Date( ) + 60 |
Uses the Between…And operator and the Date function to display records where the field’s value is between today's date and 60 days from today's date. |
> Date( ) – 30 |
Uses the Date function to display records where the field’s value is no more than 30 days before today’s date. |
Year([ShippedDate])=1996 |
Uses the Year function to display records for the year 1996. |
Year([ShippedDate])=Year(Now()) And Month([ShippedDate])=Month(Now()) |
Uses the Year and Month functions and the And operator to display records for the current year and month. |