View this page in the latest version of Appian. date() Function Share Share via LinkedIn Reddit Email Copy Link Print On This Page Function date( year, month, day ) Converts text into data accepted by the date data type and functions that require date parameters. Parameters Keyword Type Description year Integer The year of the date you would like to convert into a serial number. month Integer It month of the date in number format without leading zeros for a month with one digit. day Integer The day component of the date. Returns Date Examples 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. Dictionaries and maps 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 years 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. Gregorian calendar 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 The table below lists this function's compatibility with various features in Appian. 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 Feedback Was this page helpful? SHARE FEEDBACK Loading...