AnsweredAssumed Answered

Timestamp Calculation

Question asked by MattLeach on Apr 9, 2012
Latest reply on Apr 9, 2012 by ariley

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

Outcomes