In Access, the Date function returns the current system date.

The syntax for the Date function is:

Date ( )

Date returns a variant (date) containing a date stored internally as a Double.

Examples

Date()   returns a value such as '05.05.2005'

VBA Code

Dim MyDate MyDate = Date

Now the MyDate variable would contain the current system date.

SQL query

You can also use the Date function in a query.

SELECT Date() AS Expr1 FROM Orders