Reference > Functions reference > Text functions > GetAsTime
 

GetAsTime

Returns times or timestamps in text as field type time.

Format 

GetAsTime ( text )

Parameters 

text - any text expression or text field containing a time

Data type returned 

time

Originated in version 

6.0 or earlier

Description 

Use with formulas involving the Time or Timestamp function; use the GetAsTime or the Time function to enter a time constant into a formula. The format of the supplied time must be the same as the time format on the system where the file was created.

Example 1 

GetAsTime ( "02:47:35" ) returns 2:47:35 when you select time as the calculation result. You can perform time calculations on this result.

Example 2 

GetAsTime ( "02:47:35" ) returns 1/1/0001 2:47:35 when you select timestamp as the calculation result.

Example 3 

Abs (GetAsTime ( "12:15 pm" ) - CheckOut ) returns 3:00:00 when the CheckOut time field contains 3:15 PM.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas