Subtracts a multiple of a unit of time (e.g. seconds) from a starting date & time, returning the resulting date.
Input Fields
All three inputs are required:
- start date: the start date & time.
- subtract: (a number) how much to subtract from the start date & time.
- units: choose from the list the units that you’d like to subtract
Output Fields
- output: the date & time that comes before the start date & time as specified by the scale and unit
Examples
If _start date_ is 19-Sept-2016, subtract is 2 and units is weeks, then output will be 5-Sept-2016. If _start date_ is 19-Sept-2016 5:00pm, subtract is 8 and units is hours, then output will be 19-Sept-2016 9:00am.
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 field on the Subtract card.
Date & Time results are displayed and converted to text in ISO date format using UTC “Z” notation (i.e. not adjusted for local time zone). If you need to display a date and time in a specific time zone, use Date to Text.