time( hour, minute, second, millisecond )
Converts the given time into an equivalent time value.
| Keyword | Type | Description |
|---|---|---|
|
|
Number (Integer) |
The number of hours to add to the total. |
|
|
Number (Integer) |
The number of minutes to add to the total. |
|
|
Number (Integer) |
The number of seconds to add to the total. |
|
|
Number (Integer) |
The number of milliseconds to add to the total. |
Time
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).
1
time(14, 20, 23)
Returns 2:20 PM.
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.
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.
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 | 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 |
