bleistift2@sopuli.xyz to Science Memes@mander.xyzEnglish · 3 days agoExcel having a stab at datessopuli.xyzimagemessage-square25fedilinkarrow-up1268arrow-down18cross-posted to: memes@lemmy.world
arrow-up1260arrow-down1imageExcel having a stab at datessopuli.xyzbleistift2@sopuli.xyz to Science Memes@mander.xyzEnglish · 3 days agomessage-square25fedilinkcross-posted to: memes@lemmy.world
minus-squareDomeGuy@lemmy.worldlinkfedilinkEnglisharrow-up46arrow-down1·3 days agoIf 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.)
minus-squarebleistift2@sopuli.xyzOPlinkfedilinkEnglisharrow-up53·edit-23 days 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.
minus-squareradix@lemmy.worldlinkfedilinkEnglisharrow-up26·3 days agoYep. “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.
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.)
This meme wouldn’t exist had they done that. But they chose the zeroeth, not the first, of January for Excel.
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.