Subtract
Subtract 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 | Date and time from which a unit of time will be subtracted. | Date & Time | TRUE |
| subtract | Amount that will be subtracted from a specified date and time. | Number | FALSE |
| units |
Specific unit type (in scale) to subtract from the start date. Options are:
|
Dropdown | TRUE |
Output
| Field | Definition | Type |
|---|---|---|
| output | Resulting date and time after a specified amount of time is subtracted. The output value is an earlier date and time. | Date & Time |
Examples
| start date | subtract | units | output |
|---|---|---|---|
19-Sept-2016
|
2 | weeks | 5-Sept-2016
|
19-Sept-2016 5:00pm
|
8 | hours | 19-Sept-2016 9:00am
|
If you want to start with the current date and time, use a Now card and drag and drop the date field from the Now card into the start field on the Subtract card.
Results from Date & Time function cards are displayed and converted to text in ISO date format using UTC Z notation (not adjusted for local time zone). If you need to display a date and time in a specific time zone, use Date to Text.