Update DateTime
Adds or subtracts years, months, days, hours, minutes or seconds to a date.
Update DateTime moves a date forward or back by a whole number of years, months, days, hours, minutes or seconds. Use it to calculate due dates ("invoice date + 30 days"), reminders ("start time โ 15 minutes") or expiry dates.
Add the action
In the Process Designer toolbox, open DateTime and pick Update DateTime (or type Update DateTime in the search box).
Inputs and outputs
| Field | Direction | Type | Required | What to put / what you get |
|---|---|---|---|---|
| Date | Input | Date and time | Yes | The date to start from. |
| Unit Of Time | Input | Option list | Yes | Year, Month, Day, Hours, Minutes or Seconds. |
| Change Amount | Input | Integer | Yes | How many units to add. Use a negative number to go back in time. Default 0. |
| Updated Date | Output | Date and time | Yes | The new date. |
Example
| Date | Unit Of Time | Change Amount | Updated Date |
|---|---|---|---|
2024-03-01T10:00:00 | Day | -1 | 2024-02-29T10:00:00 |
2024-01-31T10:00:00 | Month | 1 | 2024-02-29T10:00:00 |
2024-02-29T10:00:00 | Year | 1 | 2025-02-28T10:00:00 |
2024-12-31T22:00:00 | Hours | 5 | 2025-01-01T03:00:00 |
2024-12-31T22:00:00 | Minutes | -90 | 2024-12-31T20:30:00 |
2024-12-31T23:59:30 | Seconds | 45 | 2025-01-01T00:00:15 |
Good to know
- Month ends and leap years: when the target month is shorter, the day moves to the last day of that month (31 January + 1 month = 29 February in a leap year; 29 February + 1 year = 28 February). Adding years, months or days never changes the time of day.
- Whole numbers only: Change Amount must be an integer.
1.5stops the step with an error. To add a day and a half, add36hours instead. - Time zone: a date with a UTC offset is first converted to UTC, and the result has no offset:
2024-12-31T23:00:00+02:00+ 1 day gives2025-01-01T21:00:00. - Days are calendar days. To skip weekends, check each new date with Is Weekday.