10
Date format bug? (lemmy.world)
submitted 1 year ago by 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
[–] 2 points 1 year 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.

  • permalink
  • fedilink
  • source
  • hideshow 3 child comments
    •
  • [–] [S] 1 point 1 year 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.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 6 points 1 year ago* (1 child)

    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.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 1 child comment
    •