Functions Reference

Use the GetAsTime or the Time function to enter a time constant into a formula.
Examples
GetAsTime(“02:47:35”) returns 2:47:35 when you select time as the calculation
result. You can perform time calculations on this result.
GetAsTime(“02:47:35”) returns 1/1/0001 2:47:35 when you select timestamp as the
calculation result.
Abs(GetAsTime(“12:15 pm”) - CheckOut) returns 3:00:00 when the CheckOut
time field contains 3:15 PM.
GetAsTimestamp
Format
GetAsTimestamp(text)
Parameter
text - any text expression, or text, number, date, or time field
Data type returned
timestamp
Description
Returns text as data type timestamp, for use with formulas involving timestamps. Text
strings must be in the form of a date followed by a time. A number is considered to be the
number of seconds since 1/1/0001. There are 86400 seconds in each day.
Examples
GetAsTimestamp(“4/5/2005 4:05:06”) returns 4/5/2005 4:05:06 AM.
GetAsTimestamp(50000) returns 1/1/0001 1:53:20 PM.
GetValue
Format
GetValue(listOfValues;valueNumber)
Parameter
listOfValues - a list of carriage return-delimited values
valueNumber - the value to return from the list
Data type returned
text