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.