Convert Epoch Dates to ISO 8601 - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Convert Epoch Dates to ISO 8601

Dan North

4 months ago

I have an operator that wants to send my office a monthly activity report. Problem is his report is apparently generated on a UNIX box and the date format is EPOCH. I can convert it manually by visiting a 3rd party site, but, that is time consuming, and my shop is VERY small (3 people to track 2,300+ operators and 4,000+ stations. Does anyone know how to convert it on up load to Access? Ideally he send us a .CSV or .XLSX file to import. He has agreed to change his headers to match our current database, but is unwilling or unable to change the date format.

	Adam Schwanz @Reply 4 months ago
So he is sending you a CSV or XLSX and it uploads just fine, just the date field is EPOCH? If so, you can make your own function to convert the number after you upload. Is the EPOCH date in seconds or milliseconds?

	Dan North OP @Reply 4 months ago
Honestly I am not sure. Here are some samples from a spreadsheet he sent last year. I'm just now getting a chance to look at it again as I am rewriting our old database from scratch. I can confirm he sent is in a csv format. 1733011294 1733011294 1733011296 1733011349 1733011359 1733011358 1733011360 1733011375 1733011465 1733011477 1733011478 1733011478 1733011477

	Alex Hedley @Reply 4 months ago
https://www.epochconverter.com/

	Alex Hedley @Reply 4 months ago
Excel vba : Convert Unix Timestamp to Date Time https://stackoverflow.com/a/73012724 Untested `Function fromUNIX13Digits(uT) As Date fromUNIX13Digits = CDbl(uT) / 86400000 + DateSerial(1970, 1, 1) End Function` `Public Function fromUnix10(ts) As Date fromUnix10 = DateAdd("s", CDbl(ts), "1/1/1970") End Function`

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View