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 version 



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