Syntax
ADDTODATE(<date> <string, using / another column + date constant>)
Description
Adds (or subtracts) time to a date using an integer and one date constant or another column + date constant.
| Time unit | Constant | Note |
|---|---|---|
| Year | y | |
| Quarter | q | As of Datameer X 7.4|
| Month | M | |
| Week | w | As of Datameer X 7.4|
| Day | d | |
| Hour | h | |
| Minute | m | |
| Second | s | |
| Millisecond | ms |
...