• samus12345@sh.itjust.worksEnglish
    5·
    1 day ago

    This always assumes that whatever’s in the glass is desirable. If it’s partially filled with piss, the optimist and pessimist roles would be reversed. Although Excel would remain the game.

  • wise_pancake@lemmy.caEnglish
    9·
    2 days ago

    Wouldn’t it be February first as the default in excel?

    Edit: I tested this with excel. I typed “1/2” and it automatically converted it to “02-Jan”

        • redlemace@lemmy.worldEnglish
          4·
          2 days ago

          I think it should follow regional settings, but don’t have high hopes (nor much the experience)

          • wise_pancake@lemmy.caEnglish
            4·
            2 days ago

            This brings back memories of trying to match locale info from my local computer, a remote server, a MySQL db, and a different Python app in a different server region.

            It was for an international email campaign so each users email needed to match their in app locale for number and currency formatting, but there were like a half a dozen different layers of apps and servers that all handled locales differently.

            Add in a hard deadline for the client and oof, that was a painful week.

            LC_ALL=C is now cursed knowledge that resides in my brain. I wasn’t able to install Babel or any other libraries because security reasons so I had to handle everything manually.

    • then_three_more@lemmy.worldEnglish
      2·
      2 days ago

      1/2 = 0.5 Excel counts dates 1 from 01/01/1900. Entering 0.5 and formatting as date and time gives: 00/01/1900 12:00:00 because of course it does.

  • Asafum@feddit.nlEnglish
    5·
    2 days ago

    Me: the glass is half empty and the other half sucks!

    I’m “fun” at parties. lol