MS Access: Date Function
The Microsoft Access Date function returns the current system date.
Date Function (Syntax)
The syntax for the Date function is:
The Date function can be used in the following versions of Microsoft Access:
- Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000
|Date()||would return a value such as '22/11/2003'|
Date Examples (in VBA Code)
The Date function can be used in VBA code in Microsoft Access. For example:
Dim LDate As String LDate = Date
In this example, the variable called LDate would now contain the current system date.
Date Examples (in SQL/Queries)
You can also use the Date function in a query in Microsoft Access.