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 DAY function to return the day from a given date.
* You can use the HOUR function to return the hour from a time.
* You can use the MINUTE function to return the minutes from a time.
* You can use the MONTH function to return the month from a given date.
* You can use the SECOND function to return the seconds from a time.
* You can use the TIME function to return the current system time.
* You can use the YEAR function to return the year from a given date.
* 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"