Reference > Functions reference > Text functions > GetAsTimestamp
 
GetAsTimestamp
Purpose 
Returns text as field type timestamp.
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 
Use with formulas involving timestamps. 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/2019 4:05:06" ) returns 4/5/2019 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
About timestamp fields