VBA Migration

Excel dates are based on the number of days since 1 January 1900.
Dates are based on a time value that is the number of milliseconds since 1 January 1970 UTC.


VBA.DateAdd

DATEADD - Returns the date with a specified time interval added.


VBA.DateDiff

DATEDIFF - Returns the number of a given time interval between two specified dates.


VBA.DatePart

DATEPART - Returns the specified part of a given date.


VBA.DateValue

DATEVALUE - Returns the date given a string representation of a date.




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