time() Function Share Share via LinkedIn Reddit Email Copy Link Print On This Page Function time( hour, minute, second, millisecond ) Converts the given time into an equivalent time value. Parameters Keyword Type Description hour Number (Integer) The number of hours to add to the total. minute Number (Integer) The number of minutes to add to the total. second Number (Integer) The number of seconds to add to the total. millisecond Number (Integer) The number of milliseconds to add to the total. Returns Time Usage considerations The time can be treated both as duration (for example, Joe ran the marathon in 3 hours and 23 minutes) and as a point in time (for example, we have a meeting at 3:23PM every day). Examples 1 time(14, 20, 23) Returns 2:20 PM. Lists 1 time(13, {8}) Returns 1:08 PM. 1 time({8, 9}, {1, 20}) Returns { 8:01 AM, 9:20 AM }. All lists must be the same length. 1 time(2, 5, {}) Returns {}. A value must be passed for all required arguments in order to receive a valid output. Strings 1 time("", "4") Returns 12:04 AM. An empty string acts as 0. A non-empty string is cast to number. 1 time("") Returns null. Using time as intervals 1 time(1, 70) Returns 2:10 AM. 70 minutes is treated as 1 hour and 10 minutes. 1 time(1, 10) + time(1, -10) Returns 2:00 AM. 1 hour is added and 10 minutes are subtracted from the first time. 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...