Date Function

Returns a Variant (Date) containing the current system date.




To set the system date, use the Date statement.

If you use the Date function with a Gregorian calendar, the behavior of Date$ is unchanged by the Calendar property setting. If the calendar is Hijri, Date$ returns a 10-character string of the form mm-dd-yyyy, where mm (01-12), dd (01-30) and yyyy (1400-1523) are the Hijri month, day and year. The equivalent Gregorian range is Jan 1, 1980 through Dec 31, 2099.


Use Date in an expression     You can use the Date function wherever you can use expressions. For example, you can set the Control Source property of a text box on a form as follows:


When the form is open in Form view, the text box displays the current system date.

Use the Date function in VBA code    

Note   Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.

This example uses the Date function to return the current system date.

Dim MyDate
MyDate = Date ' MyDate contains the current system date.

Applies To: Access 2013, Access 2007, Access 2010, Access 2007 Developer, Access 2010 Developer, Access 2013 Developer

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language