firefox passwords export date format unreadable/unusable
How do I convert these date values to a readable and sortable date format ???
timeCreated timeLastUsed timePasswordChanged 1.77204E+12 1.77204E+12 1.77204E+12
Need format like: 08/01/2026 or 260801 - actually sortable in date order.
All Replies (3)
They are meant for machine use. It's a timestamp in en.wikipedia.org/wiki/Unix_time — they are in seconds, so are sortable just fine (you just need to set your spreadsheet to not do any rounding etc., this exponential notation is most likely not what's in the actual CSV)
There are formulas for spreadsheet use, see stackoverflow.com/questions/45227380/convert-unix-epoch-time-to-date-in-google-sheets
Allowing the download of machine language to general users, who cannot use it, is about as stupid as it gets. They used to download actual dates that users can actually use to sort their activity.. Do these 'coders' live in China or India ??? DUM, DUM, DUM,
Since the timestamp is in seconds, you can still sort it. The lower the number, the older the record is.
The formula I shared is trivial enough to give you a datetime value in an extra column from it (with notes about spreadsheet software that understands the value and can work with it / format it on its own). Can't guarantee it was written by an American though. You'd have to inquire about that yourself on the site linked.
You must log in to your account to reply to posts. Please start a new question, if you do not have an account yet.