Access: Date Function

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.


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


Leave a Reply

Your email address will not be published.