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 4 Next »

Date/ time functions following use arguments Date Field, 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)

 

The following date/time functions are available:

                <Topic name = "dateAdd" helpContext = "attributeFunctions/dateAdd" isLeaf = "true"/>

                <Topic name = "dateDiff" helpContext = "attributeFunctions/dateDiff" isLeaf = "true"/>

                <Topic name = "dateGet" helpContext = "attributeFunctions/dateGet" isLeaf = "true"/>

                <Topic name = "dateSet" helpContext = "attributeFunctions/dateSet" isLeaf = "true"/>

                <Topic name = "getDayOfMonthAligned" helpContext = "attributeFunctions/getDayOfMonthAligned" isLeaf = "true"/>

                <Topic name = "getDayOfWeek" helpContext = "attributeFunctions/getDayOfWeek" isLeaf = "true"/>

                <Topic name = "getDayOfYear" helpContext = "attributeFunctions/getDayOfYear" isLeaf = "true"/>

                <Topic name = "getMonth" helpContext = "attributeFunctions/getMonth" isLeaf = "true"/>

                <Topic name = "getYear" helpContext = "attributeFunctions/getYear" isLeaf = "true"/>

                <Topic name = "now" helpContext = "attributeFunctions/now" isLeaf = "true"/>

                <Topic name = "removeTime" helpContext = "attributeFunctions/removeTime" isLeaf = "true"/>

                <Topic name = "timeToSecs" helpContext = "attributeFunctions/timeToSecs" isLeaf = "true"/>

                <Topic name = "today" helpContext = "attributeFunctions/today" isLeaf = "true"/>

                <Topic name = "toDate" helpContext = "attributeFunctions/toDate" isLeaf = "true"/>

                <Topic name = "toString" helpContext = "attributeFunctions/toString" isLeaf = "true"/>

 

 

 

 

 

See Also

  • No labels