Date/Time Functions

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

List of date/time functions

The following date/time functions are available:

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)

See Also

• Functions