Add or subtract time
date_addRead-onlyIdempotent
Adds or subtracts a duration (years, months, weeks, days, hours, minutes, seconds) to a date/time. Use negative numbers to subtract. Calendar-aware: adding 1 month to Jan 31 gives Feb 28/29, and adding days keeps the same local clock time across daylight-saving changes.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| days | No | days to add (negative to subtract) | |
| hours | No | hours to add (negative to subtract) | |
| weeks | No | weeks to add (negative to subtract) | |
| years | No | years to add (negative to subtract) | |
| months | No | months to add (negative to subtract) | |
| minutes | No | minutes to add (negative to subtract) | |
| seconds | No | seconds to add (negative to subtract) | |
| datetime | Yes | Date/time in ISO 8601 (e.g. "2026-03-08T14:30", "2026-03-08T14:30:00Z", "2026-03-08"), "YYYY-MM-DD HH:mm", a Unix timestamp in seconds or milliseconds, or "now". | |
| timezone | No | Time zone the arithmetic happens in. IANA time zone name, e.g. "America/New_York", "Europe/London", "Asia/Tokyo", or "UTC". Fixed offsets like "UTC+5:30" also work. Defaults to UTC. |