date_add
Add or subtract days, weeks, months, years, hours, minutes, or seconds from an ISO-8601 date, with calendar-correct results across month ends and leap years.
Instructions
Offset an ISO-8601 date by days, weeks, months, years, hours, minutes or seconds. Negative amounts subtract. Calendar-correct across month ends and leap years.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| date | Yes | Base date, e.g. 2026-01-31 | |
| unit | No | Unit (default days) | |
| amount | Yes | Amount to add; negative to subtract |