GetAsTimestamp()

Category: Text

Syntax: GetAsTimestamp ( text )

Parameters:

textAny text string or expression that returns a text string that contains a timestamp.

Data type returned: Timestamp

Description:

GetAsTimestamp() converts a timestamp contained in a text string into a data-type timestamp. It can then be used in formulas as any other timestamp would be.

GetAsTimestamp() also converts numbers into timestamps. See the Timestamp() function for more information on how timestamps can be represented as numbers.

Use GetAsTimestamp() anytime you include a literal string containing a timestamp. For instance, to find out the amount of time that has elapsed between a fixed time in the past and now, you would use the following formula:

 Timestamp (Get(CurrentDate); Get (CurrentTime) - GetAsTimestamp
 ("6/29/1969 4:23:56 PM"))

Examples:

Function	Results
GetAsTimestamp ("1/1/2004 1:10:10")	Returns 1/1/2004 1:10:10.
GetAsTimeStamp (61997169000)	Returns 8/12/1965 7:50:00 pm.