TIMESTAMPTODATE

Formula Explanation

Converts a standard timestamp to a standard date.

Formula Syntax

Enter in the result column: timestamptodate(timestamp / column number)
  • Timestamp: A 10 or 13-digit timestamp, for example, 1675851551.

Usage Example

Convert the timestamp in column ES2 to a standard date and write the result in column ES3.

ES3 = timestamptodate(ES2)

timestamptodate

Last Updated: