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-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.
|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”.|
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.
MyDate = Date ' MyDate contains the current system date.
This information was compiled using information courtesy of © Microsoft 2020. All rights reserved.