GetAsTime

Purpose

Returns times or timestamps in text as field type time.

Format

GetAsTime(text)

Parameters

Data type returned

time

Originated in

FileMaker Pro 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.

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.

Was this topic helpful? Send feedback.