Adds a multiple of a unit of time (e.g. seconds) from a starting date & time, returning the resulting date.
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: 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.