Date-Variant


These are return Variant/Date
Date
DateAdd
DateSerial
DateValue
Now


CDATE vs CVDATE

CDATE - Returns an actual Date data type
CVDATE - Returns a Variant data type whose sub type is Date. Only provided for backwards compatibility.


FORMAT$

Because you will always want to use the Format$ function to create a string containing a date, you should never use the Date$ function.
Do not allow a variable of type Date to be implicitly converted into a string. In both cases use the Format$ function to explicitly convert the date into a string



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