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.