GetAsTime
Purpose 
Returns times or timestamps in text as field type time, for use with formulas involving the Time or Timestamp functions.
Format 
GetAsTime(text)
Parameters 
text - any text expression or text field containing a time
Data type returned 
time
Originated in 
FileMaker Pro 6.0 or earlier
Description 
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.
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.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.