Reference > Functions reference > Text functions > GetAsTimestamp


Returns text as field type timestamp.


GetAsTimestamp ( text )


text - any text expression, or text, number, date, or time field

Data type returned 


Originated in 

FileMaker Pro 7.0


Use with formulas involving timestamps. Text strings must be in the form of a date followed by a time. The format of text must be the same as the numeric date format and time format on the system where the file was created. A number is considered to be the number of seconds since 1/1/0001. There are 86400 seconds in each day.

Example 1 

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