GetAsTimestamp
Purpose 
Returns text as field type timestamp, for use with formulas involving timestamps.
Format 
GetAsTimestamp(text)
Parameters 
text - any text expression, or text, number, date, or time field
Data type returned 
timestamp
Originated in 
FileMaker Pro 7.0
Description 
Text strings must be in the form of a date followed by a time. A number is considered to be the number of seconds since 1/1/0001. There are 86400 seconds in each day.
Examples 
GetAsTimestamp(“4/5/2014 4:05:06”) returns 4/5/2014 4:05:06 AM.
GetAsTimestamp(50000) returns 1/1/0001 1:53:20 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.