6 Replies Latest reply on Apr 9, 2012 1:55 PM by ariley

    Timestamp Calculation

    MattLeach

      I have a database that has a MS Access database as an external data source through ODBC from which i am importing data from.

       

      One of the fields is a TimeStamp field which is formatted as the number of seconds since 1970/01/01 00:00:00. So as an example, a record that i imported has a TimeStamp of 1326116674.

       

      I would like to create a second field that calculates the data from the TimeStamp field into a readable format. How would one go about calculating the data from the TimeStamp field into a readable date and time?

       

      Thanks