Date Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007.

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-ddyyyy, 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.

Query examples

SELECT Date() AS Expr1 FROM ProductSales GROUP BY Date();Returns the current system “date” for in short date format. Result: “dd/mm/yyyy”.
SELECT Date()-[DateofSale] AS DaysSinceSale FROM ProductSales;Returns the difference between current system “Date” and date values of the field “DateofSale” as number and displays the results in column “DaySinceSale”.

VBA examples

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.

See Also

Choose the right date function

This information was compiled using information courtesy of © Microsoft 2020. All rights reserved.

Leave a Reply

%d bloggers like this: