NOW

NOW()

Returns the current system date and time (Date).

REMARKS

* This returns the date and time from the settings from your computer.
* You can use the DATE function to return the current system date.
* You can use the TIME function to return the current system time.
* The equivalent Excel function is Application.WorksheetFunction.NOW
* The equivalent .NET function is Microsoft.VisualBasic.DateAndTime.Now
* For the Microsoft documentation refer to learn.microsoft.com

Now()=Volatile 
Debug.Print Now()      '= "01/01/2024 15:47:21"  

Dim dtDate As Date 
dtDate = Now() 
Debug.Print dtDate     '= "01/01/2024 15:47:21"