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/2022 15:47:21"

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

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top