How to read the date fields in exported password files from Firefox?
I exported the passwords from Firefox to a .CSV file. I brought the CSV file into Excel. The 3 rightmost columns are labelled timeCreated timeLastUsed timePasswordChanged. The contents appear to be 13 digit integers like 1459431833997 (in Firefox this shown as 'Mar 31, 2016').
Is there a way to have those a human-readable date fields?
Tất cả các câu trả lời (3)
Hi,
The people who answer questions here, for the most part, are other users volunteering their time (like me), not Mozilla employees or developers. If you want to leave feedback for developers, you can go to the Firefox Help menu and select Share ideas and feedback…. Alternatively, you can use this link. Your feedback gets collected by a team of people who read it and gather data about the most common issues.
You can also file a bug report or feature request. See File a bug report or feature request for Mozilla products for details.
Giải pháp được chọn
Those are UNIX Epoch dates.
When I need to do a conversion, I use this interactive site: https://www.epochconverter.com/
Since you are using Excel, maybe a formula would be efficient? https://www.google.com/search?q=excel+convert+epoch+date&client=firefox-b-1-d
Thank you.