Date/Date-time functions operate on dates date values and date&-time values.

List of date/time functions

...

 The following date-time functions are available:

...

See Also

• Functions

Arguments

Date-time functions can take arguments with the parameter types:

• Date
• Datetime

See Expression Basics.

Many date/ -time functions use take the arguments Date Field and Date Value - as described below: dateField and dateValue, which are explained below.

Anchor
dateField dateField

...

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 dateValue

...

dateValue

Date Value dateValue can either be a Numbera number, 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:

1. Monday
2. Tuesday
3. Wednesday
4. Thursday
5. Friday
6. Saturday
7. Sunday

...

For example, the following returns 6, for Saturday:

dateGet("01/07/2017", _DAY_OF_WEEK) 

See Also

...