• DomeGuy@lemmy.worldEnglish
    2·
    2 months ago

    If you think that’s bad, look at what “1” means.

    (And, honestly, at least windows’ “last big calendar change” and excel’s “start of the century when we wrote it” are reasonable points. The unix “let’s make it recent so we can fit an absurdly small unit as an integer!” Epoch is just… Weird.)

    • bleistift2@sopuli.xyzOPEnglish
      2·
      2 months ago

      “start of the century when we wrote it”

      This meme wouldn’t exist had they done that. But they chose the zeroeth, not the first, of January for Excel.

      • radix@lemmy.worldEnglish
        1·
        2 months ago

        Yep. “1” is 12:00am on 1-Jan-1900

        Numbers less than zero just give a weird error. Between zero and less than one give a nonsense date-formatted non-date.

  • psud@aussie.zoneEnglish
    2·
    2 months ago

    LibreOffice calc has

    • 0 = 1899-12-30,
    • 1= 1899-12-31,
    • 2=1900-01-01

    I wonder if they were trying to one-up excel.