Parameters Date Field and Date Time
Many date/ time functions use arguments Date Field and Date Value - as described below:
Date Field
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
Date Value
Date Value can be a Number.
For example the following will add three months to the current date and time:
dateAdd(now(), _MONTH, 3)
Alternatively, dateValue can be one of the following constants.
- _MONDAY
- _TUESDAY
- _WEDNESDAY
- _THURSDAY
- _FRIDAY
- _SATURDAY
- _SUNDAY
- _JANUARY
- _FEBRUARY
- _MARCH
- _APRIL
- _MAY
- _JUNE
- _JULY
- _AUGUST
- _SEPTEMBER
- _OCTOBER
- _NOVEMBER
- _DECEMBER
For example, if you want to set the day to Sunday, you can write:
dateSet(in.date, _DAY_OF_WEEK, _SUNDAY)
List of date/time functions
The following date/time functions are available:
<Topic name = "getDayOfWeek" helpContext = "attributeFunctions/getDayOfWeek" isLeaf = "true"/>
<Topic name = "getDayOfYear" helpContext = "attributeFunctions/getDayOfYear" isLeaf = "true"/>
<Topic name = "getMonth" helpContext = "attributeFunctions/getMonth" isLeaf = "true"/>
<Topic name = "getYear" helpContext = "attributeFunctions/getYear" isLeaf = "true"/>
<Topic name = "now" helpContext = "attributeFunctions/now" isLeaf = "true"/>
<Topic name = "removeTime" helpContext = "attributeFunctions/removeTime" isLeaf = "true"/>
<Topic name = "timeToSecs" helpContext = "attributeFunctions/timeToSecs" isLeaf = "true"/>
<Topic name = "today" helpContext = "attributeFunctions/today" isLeaf = "true"/>
<Topic name = "toDate" helpContext = "attributeFunctions/toDate" isLeaf = "true"/>
<Topic name = "toString" helpContext = "attributeFunctions/toString" isLeaf = "true"/>