PhixFlow Help

Date/Time Functions


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


List of date/time functions

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)

Day Values

The following numbers correspond to the following numbers in the date functions.

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

For example, dateGet("01/07/2017", _DAY_OF_WEEK) will return 6, because it is a Saturday.

Please note that different numbers represent the days of the week in task schedules.


See Also

Please let us know if we could improve this page feedback@phixflow.com