Access Queries  «Prev 
Setting up validation for fields

Date() function

The Date() function returns the current system date. A number of built-in functions can be used to make comparisons to dates and other types of data.
To check out some of the possibilities, use the Expression Builder by clicking on the Builder button
Builder button
Builder button
, next to the Validation Rule property. You can then work your way through the Expression Builder choices. You can see an example of this by working with the simulation in the lesson.