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.