Talk:2676: Historical Dates

Source for the Excel/Lotus 123 relation with Dec 30th, 1899: https://social.msdn.microsoft.com/Forums/office/en-US/f1eef5fe-ef5e-4ab6-9d92-0998d3fa6e14/what-is-story-behind-december-30-1899-as-base-date?forum=accessdev Victor (talk) 08:14, 24 September 2022 (UTC)

I feel this one. My birthday happens to be within 24 hours of 1970-01-01, so I keep getting caught off guard for a moment whenever I see my birthday showing up in one of these contexts. -- KarMann (talk) 08:35, 24 September 2022 (UTC)

We're going to need the date stamp format for 1890 ticker tape for this one. Anyone? 172.70.214.183 11:59, 24 September 2022 (UTC)

MM/DD/YY, with leading zeros omitted, and no I don't know why, but I suggest Google Books Ngrams might have a clue as to when that abomination started. 172.69.22.61 12:03, 24 September 2022 (UTC)

Not necessarily with pairs of the slash '/' _ . . _ . but also hyphens '-' _ . . . . _ and periods '.' . _ . _ . _ were used as delimiters in MM?DD?YY, which if I remember right dates to the 1500s when accounting ledgers were invented. 172.70.207.8 12:10, 24 September 2022 (UTC)

Are you with the NSA and have a data warehouse of all the ticker tapes ever sent or something? 162.158.166.185 12:45, 24 September 2022 (UTC)

No, but my great grandparents thought ticker tape parades were littering, because Great Grandma worked in an office and Great Grandpa worked for sanitation, so we have a bunch of boxes in the attic filled with what she was supposed to throw out her window. 172.71.158.75 12:54, 24 September 2022 (UTC)

That would be 1299. But I'm not sure how this is going to help us explain the comic, unless you perhaps are suggesting we enumerate date representation clusters somehow? 172.69.22.61 12:32, 24 September 2022 (UTC)

Someone should ask GPT-3 for a list of the top ten dates. 172.69.22.71 12:59, 24 September 2022 (UTC)

Just putting January 2, 2006 here: https://stackoverflow.com/questions/20530327/origin-of-mon-jan-2-150405-mst-2006-in-golang 172.69.22.161 12:28, 24 September 2022 (UTC)

Do we need a comment about how Pope Gregory XIII obliterated October 5th through 14th, 1582? 172.71.158.25 13:30, 24 September 2022 (UTC)

In Unix, January 1st, 1970 0h0 is 0. In Excel, December 31st, 1899 is 1. Either Randal forgot December has 31 days (hence December 30th) or he though Excel starts to count at 0 like Unix. For more information in the (probably) intentional bug in Excel https://www.joelonsoftware.com/2006/06/16/my-first-billg-review/ .

In Excel, January 1, 1900 is 1. However, December 30, 1899 is the "epoch" date that you should use if you want to convert a current date (anything on or after March 1, 1900) to a number by "subtracting" the current date minus the epoch date (counting the number of days since the epoch date). The reason it isn't December 31 is because of the above mentioned bug where Excel counts February 29, 1900 as a day even though it actually isn't.

I just checked it in different versions of Excel, you are right. Meanwhile LO Calc it is Dec 31th 1899... I'll try to edit the explaination to make it more universal. Asterisk (talk) 21:11, 24 September 2022 (UTC)

In Excel 2002 (XP) it actually interprets it as "1900-01-00" or "January 0, 1900", that's weird Asterisk (talk) 21:25, 24 September 2022 (UTC)

Speaking of dates, shouldn’t this one be in the category “Saturday comics”? Or was it still Friday in Hawaii when it came out? 162.158.107.246 17:57, 24 September 2022 (UTC)

While uploaded by the bot on 2022-09-24, the xkcd archive (and json data) states that this comic was published on 2022-09-23 —theusaf (talk) 18:44, 24 September 2022 (UTC)

The same thing happened on Monday. The comic didn't show up until Tuesday, but it was still dated Monday. Someone suggested that the book tour has been interfering with Randall's schedule. Barmar (talk) 21:25, 24 September 2022 (UTC)

I don't understand what the White Lotus Religion has to do with the comment in the title text. Nothing in the Wikipedia article linked mentions 1899 or December 30 in connection with that religion. --172.70.100.158 01:03, 25 September 2022 (UTC)

Yeah, I believe The White Lotus reference is a stretch, but it is possible, just based on the name "Lotus". This would have to be confirmed by Randall Munroe. On another matter; I'm sorry I don't have citations for Unix only becoming complete in mid-March. Dennis Ritchie himself wrote of it's birthing in 1969 in the 1978 paper,"The Evolution of the Unix Time-sharing System*" I'm quite sure of the Unix timestamp being a kind of "hack" used until a calendar app could be created. PS This Jan 1, 1970 problem was even in the first iPhones, which could be bricked by setting the date to Dec 31, 1969 or any date previous. Many an Apple Store had to put up with this nuisance. -- Cuvtixo (talk) 04:35, 25 September 2022 (please sign your comments with ~~~~)

For a number of reasons, I thought it best to revert your addition, rather than vastly edit it to make it generally better (had some good intent behind it, don't get me wrong). I thought maybe you might want to try again rather than be mercilessly re-edited into saying something you didn't mean. Didn't see your comment down here until after, though, or I might have put my energy into just prompting you to do the changes already. (I can't create a Talk page for you, in my IP state, or I might have buzzed you upon that instead.) 172.71.178.207 11:47, 25 September 2022 (UTC)