# GetAsTimestamp

Returns text as field type timestamp.

`GetAsTimestamp ( text )`

## Parameters

`text`

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

## Data type returned

timestamp

## Originated in version

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

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

About timestamp fields