Returns the current system date and time (Date).

* 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

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

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

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