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/2014 4:05:06”) returns 4/5/2014 4:05:06 AM.
GetAsTimestamp(50000) returns 1/1/0001 1:53:20 PM.
Related topics