Add
Add a multiple of a unit of time (for example, seconds) from a starting date and time and return a new date value.
Input
| Field | Definition | Type | Required |
|---|---|---|---|
| start date | Start date and time. | Date & Time | TRUE |
| add | Amount to add to the start date and time. | Number | FALSE |
| units |
Specific unit type (in scale) to add to the start date. Options are:
|
Dropdown | TRUE |
Output
| Field | Definition | Type |
|---|---|---|
| output | Resulting date and time after the specified addition | Date & Time |
Examples
| start date | add | units | output |
|---|---|---|---|
| 5-Sept-2016 | 2 | weeks | 19-Sept-2016 |
| 19-Sept-2016 9:00am | 8 | hours | 19-Sept-2016 5:00pm |
If you want to start with the current date and time, use a Now card and drag/drop the date field from the Now card into the start date field on the Add card.
Results for this card are displayed and converted to text in ISO date format using UTC Z notation (that is, not adjusted for local time zone). If you need to display a date and time in a specific time zone, use Date to Text.