Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt
hiddentrue

Functions which handle dates.

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


List of date/time functions

Page Tree
root@self
excerpttrue

Parameters: Date Field and Date Time

Many date/ time functions use arguments Date Field and Date Value - as described below:

Anchor
dateField
dateField
Date Field

Date Field can take one of the following values:

...

dateSet(in.date, _DAY_OF_WEEK, _SUNDAY)

 

 

                <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"/>

 

 

 

 

...

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.

Info

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


See Also