Versions Compared

Old Version 4

changes.mady.by.user Chris Welford

Saved on

compared with

New Version Current

changes.mady.by.user Sarah Holland

Saved on

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

The following date/time functions are available:

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

...

dateSet(in.date, _DAY_OF_WEEK, _SUNDAY) 

Day Values

The following numbers correspond to the following numbers in the 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"/>

 

 

 

 

...

.

  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