Last_update in readable format

#1

Hi,
In the export file from S2Member I see a field called ‘meta_key__last_update’. In excel this field has a value, but not readable for me. Is there a way to have it in understandable format?

#2

This is the date, but in “Unix timestamp” format, number of seconds. Is there in Excel such date type?

#3

Hi Krum,

Thanx for you response: Excel does not support these kind of data (as they are Windows-oriented)
But I found a formula that should help:
=(XXXX/86400)+25569+(1/24)
And when I fill in a value: e.g. 42487,81076 it should give me the number of days. And, Excel can reformat to dd-mm-yyyy, as I expect.
But, with Microsoft there is alway a but…All values are in the same range, and are 1-1-1970. Surprising…
I remoced the decimal comma, but in that case the outcome was far in the future…
So, no solution currently
Any help appreciated

#4

How about this: http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps/

#5

All,
Indeed I used that page to identify a solution. It could be the problem is in the source data. My Windows 10 uses European settings. Could also be the reason why I have to change data in an export file before I open the csv with Excel.
It is a bit weird the unix timestamp contains a comma, which we in Europa consider as a decimal comma. What should the source data look like? Without decimal comma I assume?

#6

Have you tried using LibreOffice Calc instead of Excel? I find that LO Writer is much less problematic than Word, so I’m wondering if the same might be true of its speadsheet sibling.

#7

Hi @AustinHealey, please show here the initial value. Timestamps starts with “14”, should be integer (no comas or dots) and have 12-14 numbers (fixed length, but I can not remember right now). What you describe seems different…

There is another “reverse timestamp” format, but s2M don’t use that… Or there is a problem with export?