Skip Navigation
techsupport @sopuli.xyz
InternetCitizen2 @lemmy.world

Date format bug?

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.

4 comments

  • 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.

    • 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.

      • 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.