Functions Reference

Chapter 12
|
Text functions 163
GetAsTime
Format
GetAsTime(text)
Parameter
text - any text expression or text field containing a time
Data type returned
time
Description
Returns times or timestamps in text as data type time, for use with formulas involving
the Time or Timestamp functions. The format of the supplied time must be the same as
the time format on the system where the file was created.
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/2009 4:05:06”) returns 4/5/2009 4:05:06 AM.
GetAsTimestamp(50000) returns 1/1/0001 1:53:20 PM.