Your timestamp is down to the millisecond, try this calc instead:
DATEADD('second',[Event Audit Time Stamp]/1000,#1970-01-01#)
thanks for the reply, Jonathan
That calculation is one that I tried early on (from looking at the forum), but it errors: "Can't divide a string value by integer value".
Also tried DATEADD('second',INT([Event Audit Time Stamp])/1000,#1970-01-01#) but same error.
It's close with the INT inserted...but not correct, hence the incorrect Month and Day, not to mention the 44632 that tails the result.
Still at a loss.
I set up a workbook with the timestamp as a string field and tried your version of it in the latest reply and I get the correct result. Is there any chance you can post a packaged workbook (.twbx) with just that row of data?
Jonathan, Thank you for your timely responses.
Ok. I am perplexed. Started stripping the proprietary data so I could package the workbook and upload it…looked at the data again and wha-la…it works.
I actually do a two-step process:
1) Pull the Time Stamp Data from a field that has multiple sets of data separated by comma’s and/or carriage returns using this formula: Event Audit Time Stamp = MID(STR([Event Annotation Audit Trai]),3,13)
2) Convert the finding to a human readable Date and Time using this formula - DATEADD('second',INT([Event Audit Time Stamp])/1000,#1970-01-01 00:00:00#)
Lastly, make these calculations BEFORE you extract the data. I continued to received errors until I stopped using the extract, created the calculated fields, then extracted the data.
Hopefully this helps others with similar situations.