In This Topic
Function Name
|
DateAdd |
Category
|
DateTime |
Icon
|
|
Description
|
Adds or subtracts a number of days/hours/minutes/seconds from an Date/Datetime |
Inputs
|
Date |
The Date/DateTime/Time to add to |
Days |
The number of days to add (can be a negative number) |
Hours |
The number of hours to add (can be a negative number) |
Minutes |
The number of minutes to add (can be a negative number) |
Seconds |
The number of seconds to add (can be a negative number) |
Milliseconds |
The number of milliseconds to add (can be a negative number) |
|
Outputs
|
Result |
A Date time with the days/hours/minutes/seconds added to it |
|
Properties
|
|
Usage
The Data Mapper DateAdd function takes an existing Date/DateTime/Time value and adds on a number of days/hours/minutes/seconds, the resulting DateTime is then returned.
In order to subtract, use negative number for days/hours/minutes/seconds.
See Also