Free cookie consent management tool by TermsFeed timevalue() Function
timevalue() Function

Function

timevalue( time_text )

Converts the given time into an equivalent interval.

Parameters

Keyword Type Description

time_text

Text

The time of day to be converted into an interval.

Returns

Time

Examples

1
timevalue()

Returns 0::00:00:00.001.

Use with time

1
timevalue(time(14,20,23))

Returns 2:20 PM.

Use with date and time

1
timevalue(datetime(2011, 2, 28, 12, 0, 0))

Returns 12:00 PM.

Use with integers, decimals, and lists

1
timevalue(0)

Returns 12:00 AM.

1
timevalue(9.9,8.098,{5,6})

Returns {9:36 PM, 2:21 AM, 12:00 AM, 12:00 AM}.

1
timevalue(9.9,8.098,1234.2)

Returns {9:36 PM, 2:21 AM, 4:48 AM}. timevalue({9.9,8.098,1234.2}) has the same result.

Use with text

1
timevalue("4::12:12:12.013", "23:09")

Returns {12:18 AM, 11:09 PM}.

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

timevalue() Function

FEEDBACK