Developer forum

Hi Hans,

• Create an excel column where you substring the XML and only get the value the timestamp
• Then have another excel column and convert the ticks to a datetime - https://www.extendoffice.com/documents/excel/2473-excel-timestamp-to-date.html#:~:text=time%20you%20typed.-,Convert%20timestamp%20to%20date,to%20a%20range%20you%20need.
• You can do everything in a single column, but it will be messier at first

Best Regards,

Nuno Aguiar

Thank you very mutch Nuno 🙏

I think i stille have an issue with the dateformat. Converting 8585578580894875792 here, should give the same result https://www.epochconverter.com/ ?

But that gives me a date in year 2042. I got a reply from support, saying that is because i have to use GetBinary, but since we want to do it directly in Excel, that is not possible.

Does that mean the initial timestamp format is not a "universal" format, and therefore - it can´t be done in Excel, or is this another format that i am not aware of?

/Hans

Hi Hans,

Not sure. Try this formula instead https://www.extendoffice.com/documents/excel/3467-excel-convert-serial-number-to-date.html#:~:text=do%20as%20follows.-,1.,need%20to%20convert%20to%20date.

I'm no expert in Excel, but from time to time I have to do some wacky things with it, so I try to google it as much as I can. The rule of thumb has always been to try to create some columns to get your partial values, because excel formulas can get messy pretty quick and it's hard to understand.

Best Regards,

Nuno Aguiar

Thanks Nuno

Have tried converting from serial number, but that gives an error. Appears the dateformat in the export is quite unique and non-standard. I have also tried different online date converters, but nothing gives the right result.

I have appealed to the DEV department use standardised date format like Unix/Epoch.

/Hans