Reference > Functions reference > Text functions > GetAsTimestamp
 

GetAsTimestamp

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. 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