Access Reference

Date and time criteria expressions

To specify date or time criteria for an operation, you supply a date or time value as part of the string expression that forms the _criteria_ argument. This value must be enclosed in number signs (#).

> NOTE: > The number signs indicate to Access that the _criteria_ argument contains a date or time within a string.

Suppose that you are creating a filter for an Employees form to display records for all employees born on or after January 1, 1960. You could construct the _criteria_ argument for the form’s Filter.md) or ServerFilter property as in the following example. Note the placement of the number signs.

vb Forms!Employees.Filter = "[BirthDate] >= #1-1-1960#"

!include[Support and feedback]

6 community Q&A using Date and time criteria expressions

Libraries that work with Date (5)

113 wordsMicrosoft Docs rev. 09/21/2018