...
| Excerpt | ||
|---|---|---|
| ||
Functions which handle dates. |
Date/-time functions operate on dates and date and date-time values.
List of date/time functions
The following date
...
-time functions are available:
| Page Tree | ||||
|---|---|---|---|---|
|
See Also
Parameters: Date Field and Date Time
Many date/ -time functions use the arguments Date Field and Date Value - as described below: DateField and DateValue.
| Anchor | ||||
|---|---|---|---|---|
|
...
DateField
Date Field DateField 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 | ||||
|---|---|---|---|---|
|
...
DateValue
Date Value DateValue can either be a Numbernumber, representing a month or day, or a constant.
For example the following will , to add three months to the current date and time, use:
dateAdd(now(), _MONTH, 3)
Alternatively, dateValue can be one of the following constants.The constants are:
- _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 writeuse:
dateSet(in.date, _DAY_OF_WEEK, _SUNDAY)
...
Months and Days as Numbers
The following numbers correspond to the following numbers in the date functions.numbers returned by data functions:
- for the months are 1 for January through to 12 for December.
- for the days are:
- Monday
- Tuesday
- Wednesday
- Thursday
- Friday
- Saturday
- Sunday
For example, the following returns 6, for Saturday:
dateGet("01/07/2017", _DAY_OF_WEEK)
...
| Note |
|---|
When scheduling tasks, the days of the week in task schedulesare represented by different numbers. |
See Also