Date Function Example

You can use the Date function in a calculated control by setting the ControlSource property of the control as in the following example.

= Date()

You can also use the Date function to set criteria for a query. For example, if you have an Orders table that contains an OrderDate field, you can create a query on the Orders table to return all records that have an OrderDate between 4-1-95 and today's date. Enter the following in the Criteria cell under the OrderDate field.

Between #4-1-95# and Date()