DATE - Statement

DATE()

Defines the current system date.

REMARKS

* This must be a date between 1 January 1980 and 31 December 2099.
* Changing your system date using this statement is not recommended. You may get a permission denied message if you do not have administrator rights on that computer.
* Is there any restriction on the date range - does it have to be after 1st January 1980.
* This statement is not available in Access.
* This statement should be prefixed with "VBA." to make the code easier to understand.
* You can use the DATE Function to return the current system date.
* You can use the NOW function to return the current system date and time.
* You can use the TIME Function to return the current system time.
* You can use the TIME Statement to set the system time.
* For the Microsoft documentation refer to learn.microsoft.com

VBA.Date = #February 01, 2025# 
VBA.Date = #1/1/2024#