date( year, month, day )
Converts text into data accepted by the date data type and functions that require date parameters.
Keyword | Type | Description |
---|---|---|
|
Integer |
The year of the date you would like to convert into a serial number. |
|
Integer |
It month of the date in number format without leading zeros for a month with one digit. |
|
Integer |
The day component of the date. |
Date
1
date(2009,7,22)
Returns 7/22/2009
.
1
date(2009,7,{22})
Returns 7/22/2009
.
1
date({2009, 2008},{7, 4},{22, 18})
Returns {7/22/2009, 4/18/2008}
. All lists must be the same length.
1
date(2009,7,{})
Returns {}
. A value must be passed for all arguments to receive a valid output.
1
date(10000, 10, 9)
Returns null
. A null date is returned for invalid month or day values (such as 13
or 35
, respectively) and for year values greater than 9999
or between 99 and 1000
.
1
date(2022, {month: 10}.month, 31)
Returns 10/31/2022
.
1
date(2022, a!map(month: 10).month, 31)
Returns 10/31/2022
.
Two-digit year values are converted to twenty-first century years when the value is between 0
and 19 years from the current year. For example, if the current year is 2023, year values from 0
to 42
are converted to four-digit years like 2000
and 2042
.
1
date(12, 10, 31)
Returns 10/31/2012
.
1
date(63, 10, 31)
Returns 10/31/1963
.
1
date(1582, 10, 22)
Returns 10/22/1582
. Dates before this date will diverge from the input due to the introduction of the Gregorian calendar.
1
date(1220, 10, 22)
Returns 10/15/1220
.
Feature | Compatibility | Note |
---|---|---|
Portals | Compatible | |
Offline Mobile | Compatible | |
Sync-Time Custom Record Fields | Compatible | Can be used to create a custom record field that only evaluates at sync time. |
Real-Time Custom Record Fields | Incompatible | Custom record fields that evaluate in real time must be configured using one or more Custom Field functions. |
Process Reports | Compatible | |
Process Events | Compatible |
date() Function