Access: Date Function

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

The syntax for the Date function is:

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

Date()   returns a value such as '05.05.2005'

Dim MyDate 
MyDate = Date

Now the MyDate variable would contain the current system date.

You can also use the Date function in a query.

SELECT Date() AS Expr1 
FROM Orders

Related Posts