You can also use the Is Date function in a query in Microsoft Access.
Validation rules prevent bad data being saved in your table. You can create a rule for a field (lower pane of table design), or for the table (in the Properties box in table design.) Use the table's rule to compare fields. In some versions of Access, you will not be able to leave the field blank once you add the validation rule, i.e. If you need to be able to leave the field blank, add OR Is Null to your rule.
Let's say we have a database that tracks applicants and case workers, and when cases are assigned, signed out, and closed.
Following this example, let's say we would like to automate the date for when a case is received.
Access provides a number of ways to restrict input: You can use these methods of validating data alone or in combination with each other.
Just as with numbers, writing validation rules for dates is a matter of testing if a data is greater or smaller than a certain date, or testing if a date is withing a certain range.
Dates in Access are written between number signs (#).
A validation rule is one way to restrict input in a table field or a control (such as a text box) on a form.
Validation text lets you provide a message to help users who input data that is not valid.