Home Privacy Policy Feedback Link to us Site Map Forums

Access: Date Function


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

The syntax for the Date function is:

Date ()


For example:

Date() would return a value such as '22/11/2003'

VBA Code

The Date function can be used in VBA code. For example:

Dim LDate As String

LDate = Date

In this example, the variable called LDate would now contain the current system date.


SQL/Queries

You can also use the Date function in a query.