Syntax
ROUNDTIME(<date>;<string, using a time constant>)
...
| Time unit | Constant |
|---|---|
| Day | d |
| Hour | h |
| Minute | m |
| Second | s |
Limitation
This function can't be applied to an empty value. If a column contains empty values, consider adding a check for this, e.g.
| No Format |
|---|
IF(ISBLANK(#DateColumn); null; ROUNDTIME(#DateColumn; "1d")) |
...