September 1999 was a heck of a month you maybe remember. There that all that excitement of the Moon being blasted out of orbit thanks to the nuclear waste pile up there getting tipped over or something. And that was just as we were getting over the final new episode of Mystery Science Theater 3000‘s first airing. That episode was number 1003, Merlin’s Shop of Mystical Wonders, which aired a month after the season finale because of one of those broadcast rights tangles that the show always suffered through.
Time moves on, and strange things happen, and show co-creator and first host Joel Hodgson got together a Kickstarter and a Netflix deal. The show’s Season Eleven is supposed to air starting the 14th of April, this year. The natural question: how long will we go, then, between new episodes of Mystery Science Theater 3000? Or more generally, how do you work out how long it is between two dates?
The answer is dear Lord under no circumstances try to work this out yourself. I’m sorry to be so firm. But the Gregorian calendar grew out of a bunch of different weird influences. It’s just hard to keep track of all the different 31- and 30-day months between two events. And then February is all sorts of extra complications. It’s especially tricky if the interval spans a century year, like 2000, since the majority of those are not leap years, except that the one century year I’m likely to experience was. And then if your interval happens to cross the time the local region switched from the Julian to the Gregorian calendar —
So my answer is don’t ever try to work this out yourself. Never. Just refuse the problem if you’re given it. If you’re a consultant charge an extra hundred dollars for even hearing the problem.
All right, but what if you really absolutely must know for some reason? I only know one good answer. Convert the start and the end dates of your interval into Julian Dates and subtract one from the other. I mean subtract the smaller number from the larger. Julian Dates are one of those extremely minor points of calendar use. They track the number of days elapsed since noon, Universal Time, on the Julian-calendar date we call the 1st of January, 4713 BC. The scheme, for years, was set up in 1583 by Joseph Justus Scalinger, calendar reformer, who wanted for convenience an index year so far back that every historically known event would have a positive number. In the 19th century the astronomer John Herschel expanded it to date-counting.
Scalinger picked the year from the convergence of a couple of convenient calendar cycles about how the sun and moon move as well as the 15-year indiction cycle that the Roman Empire used for tax matters (and that left an impression on European nations). His reasons don’t much matter to us. The specific choice means we’re not quite three-fifths of the way through the days in the 2,400,000’s. So it’s not rare to modify the Julian Date by subtracting 2,400,000 from it. The date starts from noon because astronomers used to start their new day at noon, which was more convenient for logging a whole night’s observations. Since astronomers started taking pictures of stuff and looking at them later they’ve switched to the new day starting at midnight like everybody else, but you know what it’s like changing an old system.
This summons the problem: so how do I know many dates passed between whatever day I’m interested in and the Julian Calendar 1st of January, 4713 BC? Yes, there’s a formula. No, don’t try to use it. Let the fine people at the United States Naval Observatory do the work for you. They know what they’re doing and they’ve had this calculator up for a very long time without any appreciable scandal accruing to it. The system asks you for a time of day, because the Julian Date increases as the day goes on. You can just make something up if the time doesn’t matter. I normally leave it on midnight myself.
So. The last episode of Mystery Science Theater 3000 to debut, on the 12th of September, 1999, did so on Julian Date 2,451,433. (Well, at 9 am Eastern that day, but nobody cares about that fine grain a detail.) The new season’s to debut on Netflix the 14th of April, 2017, which will be Julian Date 2,457,857. (I have no idea if there’s a set hour or if it’ll just become available at 12:01 am in whatever time zone Netflix Master Command’s servers are in.) That’s a difference of 6,424 days. You’re on your own in arguing about whether that means it was 6,424 or 6,423 days between new episodes.
If you do take anything away from this, though, please let it be the warning: never try to work out the interval between dates yourself.
3 thoughts on “How To Work Out The Length Of Time Between Two Dates”
And I figured the routine date and time conversion mess you face as a software developer is a challenge ;-) …
Oh you have no idea. In that one ancient database was designed with every column a string, and dates entered as literally, eg, ’03/10/2017′. That string of text. Which was all right when the date just had to be shown on-screen but then I had said it should be easy to include a date range, unaware of just what was in the database. Also, that there are so many mistakes too. Or people entering 00/00/0000 when the date wasn’t available.
LikeLiked by 1 person