Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Text functions > GetAsTime function |
|
|
| GetAsTime function |
| 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. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Text functions > GetAsTime function |
|
|
Next Page |
|