• QuantumEraser@fedia.ioOP
      link
      fedilink
      arrow-up
      2
      ·
      2 days ago

      Yeah sorry about that, was the default format in my spreadsheet software and I didn’t think to change it

        • calcopiritus@lemmy.world
          link
          fedilink
          arrow-up
          6
          arrow-down
          1
          ·
          2 days ago

          I wish. Am European. I know one person that voluntarily uses their date and time formats. For reasons I will never comprehend.

          • Jiral@lemmy.world
            link
            fedilink
            arrow-up
            5
            ·
            2 days ago

            He or she must enjoy the endless confusion and friction in the interaction with others. That said, some idiotic IT systems use the US format to. Causes a lot of problems.

            • Laurel Raven@lemmy.zip
              link
              fedilink
              English
              arrow-up
              4
              ·
              2 days ago

              I’m in the US and have had problems with C-level douches misreading dd-mm-yyyy dates in some system we had that logged in that format and freaking out (and also missing that the log time stamps were in UTC-0, causing further confusion/freakout)

              Anyway, this is part of why I always use yyyy-mm-dd, because nobody will confuse that date string for any other date, and everyone who can understand dates at all will be able to read it.

          • glimse@lemmy.world
            link
            fedilink
            arrow-up
            18
            ·
            edit-2
            2 days ago

            NO. You need a character per digit and you always want the leading 0 shown.

            YYYY-MM-DD

                  • glimse@lemmy.world
                    link
                    fedilink
                    arrow-up
                    2
                    ·
                    2 days ago

                    …And you assume you will only ever look at those files with that file manager forever…

                    There is no downside to writing the leading zeroes pretty much anywhere except when aesthetics matter (event flyers, etc)

            • palordrolap@fedia.io
              link
              fedilink
              arrow-up
              3
              ·
              2 days ago

              It’s close, sure, but actually no. That standard currently requires the letter T (and no white-space) between date and time when both are present, and, frankly, that’s ugly and a space should be allowed.

              An old version of the standard allowed the space, and GNU’s coreutils seem to have carried on the tradition, so I’m not alone in thinking this.

            • zqps@sh.itjust.works
              link
              fedilink
              arrow-up
              6
              ·
              2 days ago

              No because it’s the global format that typically uses periods.

              D.M.Y (normal)
              Y-M-D (superior)
              M/D/Y (mental illness)

              Mixing up the formats and denominators makes this mess even worse.