Adds 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.
  • add: (a number) how much to add to the start date & time.
  • units: choose from the list the units (in scale) that you’d like to add.

Output Fields

  • output: the date & time that comes after the start date & time as specified

Examples If _start date_ is 5-Sept-2016, add is 2 and units is weeks, then output will be 19-Sept-2016. If _start date_ is 19-Sept-2016 9:00am, add is 8 and units is hours, then output will be 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.

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.