DATE()

Returns the current system date (Date).


REMARKS
* To set the system date, use the DATE statement.
* When used in the editor, 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()
Date() = Volatile
Date() = "22/10/2003"
Format(Date(),"dd mmm yyyy hh:mm:ss") = "09 May 2008 00:00:00"
Format(Date() + Time(),"dd mmm yyyy hh:mm:ss") = "09 May 2008 12:15:59"

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