Date/Time Functions

Owned by Former user (Deleted)
Oct 12, 2015
1 min read

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