DATE()

Returns the current system date (Date).


REMARKS
* To set the system date, use the DATE statement.
* The default format is "dd/mm/yyyy" (or "mm/dd/yyyy" in the US).
* When this is used in the VBA Editor the brackets are automatically removed.
* You can use the DATE$ function to return a String data type instead of a Variant/String data type.
* This function can be prefixed with "VBA."
* For the Microsoft documentation refer to docs.microsoft.com

Dim lSerial As Long 
lSerial = Date()
Debug.Print lSerial = 44033

Dim sDate As String
sDate = Date()
Debug.Print sDate = 21/07/2020

Dim dtDate As Date
dtDate = Date()
Debug.Print dtDate = 21/07/2020

Format(Date(),"dd mmm yyyy hh:mm:ss") = "21 Jul 2020 00:00:00"
Format(Date() + Time(),"dd mmm yyyy hh:mm:ss") = "21 Jul 2020 12:15:59"

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