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:

...

dateSet(in.date, _DAY_OF_WEEK, _SUNDAY)

...

Day Values

The following date/time functions are available:

dateAdd

dateDiff

dateGet

dateSet

 

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