this post was submitted on 27 Jul 2025
10 points (100.0% liked)

techsupport

163 readers
1 users here now

Having tech problems?

Ask other users, and try to help others with their problems as well.

Guidelines

Please include your system specs, such as Windows/Linux/Mac version/build, model numbers, troubleshooting steps, symptoms, etc.

founded 2 years ago
MODERATORS
sting@sopuli.xyz
10
Date format bug? (infosec.pub)
submitted 5 days ago* (last edited 5 days ago) by InternetCitizen2@lemmy.world to c/techsupport@sopuli.xyz
4 comments fedilink hide all child comments
 

cross-posted from: https://lemmy.world/post/33569521

Does anyone know why the "render" of the data would be wrong? I changed it from the US format to the ISO 8601.

Edit: Adding some spaces in the equation helped.

you are viewing a single comment's thread
view the rest of the comments
[–] jbrains@sh.itjust.works 2 points 5 days ago* (last edited 5 days ago) (3 children)

The reference date (the date that 0 represents) is not set as you expect. This happened to me when I imported Numbers files into LibreOffice Calc and is the reason I know about this at all.

[–] InternetCitizen2@lemmy.world 1 points 5 days ago (2 children)

The reference date (the date that 0 represents) is not set as you expect.

It is not clear to me what this means. But my data was typed in rather than imported from somewhere else if that matters.

[–] jbrains@sh.itjust.works 6 points 5 days ago* (last edited 5 days ago) (1 children)

I don't remember what LibreOffice calls it, but there is an option to choose which dates are the starting points for counting, so that 0 corresponds to different dates for reasons of compatibility with other spreadsheet systems. Yours is not set to what you're expecting.

One of the options is 4 years 1 day later than the LibreOffice standard, which explains why those dates are off by that much.

There is a setting per workbook and possibly a global setting that would affect all new workbooks until you change it.

Search the web for something like "1904 date option LibreOffice Calc" and you'll find out the details. Good luck.

[–] InternetCitizen2@lemmy.world 1 points 5 days ago

Thanks for the tip, I'll investigate it :)