Adds time to a DATETIME value and returns the new DATETIME.
newDT=AddDateTime (Datetime=[, iDays, iHours, iMins, iSecs, iMsecs])
Variable | Description |
---|---|
newDT | Returned sum of datetime and specified time values. DATETIME. |
Datetime | The original DATETIME value. DATETIME. |
iDays | Optional. A day’s value to add to Datetime. INTEGER. |
iHours | Optional. An hour’s value to add to Datetime. INTEGER. |
iMins | Optional. A minute’s value to add to Datetime. INTEGER. |
iSecs | Optional. A second’s value to add to Datetime. INTEGER. |
iMsecs | Optional. A microsecond’s value to add to Datetime. INTEGER. |
The DATETIME data type represents values from 4713 BC to 19999 AD. You can use this function to add positive or negative numbers to a DATETIME value. The optional values are not artificially constrained—for example, you are not limited to values less than 24 for iHours or less than 60 for iMins. Remember that there is no year zero.
To skip over an optional argument, use NULL as a placeholder.
datetime = GetDateTime () // increment current time by one hour newDateTime = AddDateTime (datetime, NULL, 1)