Increment Date
Add/subtract time intervals
What It Does
Increment Date adds or subtracts a time interval from a date column. Use negative numbers to go backward in time.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Increment Date". It's in the Date group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Column | Column select (date) | Yes | The date column to modify |
Amount | Number | Yes | Number of units to add (negative to subtract) |
Unit | Select | Yes | day, week, month, year, hour, minute |
SQL generated under the hood
SELECT *, order_date + INTERVAL '30 day' AS due_date FROM dataRelated Operations
- Extract Date Part - Extract year, month, day from a date
- Date Difference - Calculate difference between two dates