Difference between revisions of "Talk:2676: Historical Dates"

Explain xkcd: It's 'cause you're dumb.
Jump to: navigation, search
Line 24: Line 24:
 
Speaking of dates, shouldn’t this one be in the category “Saturday comics”? Or was it still Friday in Hawaii when it came out? [[Special:Contributions/162.158.107.246|162.158.107.246]] 17:57, 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? [[Special:Contributions/162.158.107.246|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 —[[User:Theusaf|theusaf]] ([[User talk:Theusaf|talk]]) 18:44, 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 —[[User:Theusaf|theusaf]] ([[User talk: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. [[User:Barmar|Barmar]] ([[User talk:Barmar|talk]]) 21:25, 24 September 2022 (UTC)

Revision as of 21:25, 24 September 2022

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)

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)