bleistift2@sopuli.xyz to Science Memes@mander.xyzEnglish · 1 day agoExcel having a stab at datessopuli.xyzimagemessage-square23fedilinkarrow-up1258arrow-down18
arrow-up1250arrow-down1imageExcel having a stab at datessopuli.xyzbleistift2@sopuli.xyz to Science Memes@mander.xyzEnglish · 1 day agomessage-square23fedilink
minus-squareDomeGuy@lemmy.worldlinkfedilinkEnglisharrow-up46arrow-down1·1 day 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-21 day 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·1 day 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.