Category: Text
Syntax: GetAsTime ( text ) |
Parameters:
textAny text expression or text field containing a time.
Data type returned: Time
Description:
GetAsTime() returns the data specified in the text string as data-type time. The value can then be manipulated like any other time data.
GetAsTime() can be used to convert an integer representing a number of seconds into an elapsed time, as demonstrated in the third of the following examples.
Examples:
Function |
Results |
---|---|
GetAsTime ("01:30:30") |
Returns 1:30:30 AM when you specify Time as the calculation result. |
GetAsTime ("01:30:30") |
Returns 1/1/0001 1:30:30 AM when you specify Timestamp as the calculation result. |
GetAsTime (48000) |
Returns 8:53:20. |
Using GetAsTime() when working with literal time strings in calculation formulas
GetAsTime ("15:30:00") - FinishTime
would yield the elapsed time between 3:30 p.m. and the FinishTime.
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
Calculation Signatures
Calculation Functions
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Scripting Primer
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information