Category: Text

Syntax: GetAsTimestamp ( text )


textAny text string or expression that returns a text string that contains a timestamp.

Data type returned: Timestamp


GetAsTimestamp() converts a timestamp contained in a text string into a data-type timestamp. It can then be used in formulas as any other timestamp would be.

GetAsTimestamp() also converts numbers into timestamps. See the Timestamp() function for more information on how timestamps can be represented as numbers.

Use GetAsTimestamp() anytime you include a literal string containing a timestamp. For instance, to find out the amount of time that has elapsed between a fixed time in the past and now, you would use the following formula:

 Timestamp (Get(CurrentDate); Get (CurrentTime) - GetAsTimestamp
 ("6/29/1969 4:23:56 PM"))




GetAsTimestamp ("1/1/2004 1:10:10")

Returns 1/1/2004 1:10:10.

GetAsTimeStamp (61997169000)

Returns 8/12/1965 7:50:00 pm.

: 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

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352 © 2008-2020.
If you may any questions please contact us: