| Excerpt | ||
|---|---|---|
| ||
Functions which handle dates. |
...
time functions operate on dates and date&time values.
List of date/time functions
The following date/time functions are available:
| Page Tree | ||||
|---|---|---|---|---|
|
Parameters: Date Field and Date Time
Many date/ time functions use arguments Date Field and Date Value - as described below:
| Anchor | ||||
|---|---|---|---|---|
|
Date Field can take one of the following values:
- _YEAR
- _MONTH
- _DAY (equivalent to _DAY_OF_MONTH)
- _DAY_OF_WEEK
- _DAY_OF_MONTH
- _DAY_OF_YEAR
- _WEEK_OF_YEAR
- _HOUR
- _MINUTE
- _SECOND
- _MILLISECOND
| Anchor | ||||
|---|---|---|---|---|
|
Date Value can be a Number.
For example the following will add three months to the current date and time:
...
dateSet(in.date, _DAY_OF_WEEK, _SUNDAY)
See Also