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 (that is, not adjusted for local time zone). If you need to display a date and time in a specific time zone, use Date to Text.