Format date from raw number

foobar's play statistics inserts date information as a rather big number, e.g.
(That should be the 27th of January 2021, around 2pm.)

Can someone please tell me how to convert the display of that number back to the human date conventions so that I see the day, month, year, perhaps even time?

Maybe this answer could help:;topicseen#msg92771

This number

"is a 64-bit value that represents the number of 100-nanosecond intervals that have elapsed since 12:00 A.M. January 1, 1601 Coordinated Universal Time (UTC)."

My Excel result:

My LibreOffice Calc result:

Both are not able to accept such a big number as 132562253706194673 completely... :wink:

You can convert your number with this Windows PowerShell-Command:

PShell> [datetime]::FromFileTime("132562253706194673")

Mittwoch, 27. Januar 2021 13:49:30

If you are looking for technical details, including the UTC/GMT issue:

In Mp3tag, the formula would look like this:
assuming, your number 132562253706194673 is saved in %FOOBARPLAYSTATISTICS%.

I have no idea how we can convert the resulting number 44222 into a readable human date...

1 Like

I was looking for a way to define a column for that value ... and hoping that there are some boffins out there who regurlarly convert such a number into a data.
Looks like a real task now.
But thank you so far. Very much indeed.

1 Like