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.