PhixFlow Help

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

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

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

See Also

  • No labels