I've actually used this a couple of times in the past week; it calculates the distance between dates. Very useful for journalists working on a story.
Posted by Jane Galt at June 13, 2007 5:14 PM | TrackBack | $raw=rawurlencode($_SERVER['PHP_SELF']); $technolink="http://www.technorati.com/cosmos/links.html?rank=&url=http%3A%2F%2Fwww.janegalt.net$raw"; echo ("Technorati inbound links"); ?>I think this is slightly more useful for journalists: http://www.weirdconverter.com/
Posted by: Cisco on June 13, 2007 5:28 PMI'm probably missing something, but what does this do that cannot be done by subtracting two dates in Excel?
Posted by: per on June 14, 2007 3:10 AMI'm obviously missing something too. I mean, I'm married now, but I'm pretty sure that back in the day I found it pretty simple to calculate the distance between dates.
Posted by: Tim Worstall on June 14, 2007 5:18 AMUse Excel to build a template. Use some of the mathematical and logic skills which got you into U. Chicago Business School!
Posted by: Dave on June 14, 2007 6:58 AMDate calculations can be tougher than you might think. Not only do you need to take into account leap years (and how many people know about the century rules for leap years) but depending on the accuracy required you might need to deal with shifting time zones, differing calendars (e.g. Gregorian vs. Julian), and even the time of day in some cases.
Many computer languages (such as Java) have a complex set of classes for dealing with times and dates.
Posted by: Geoff Shotts on June 14, 2007 8:24 AM'Distance' betweeen two dates??
Is this some kind of corollary to the fact that that “Time is the greatest distance between two places.”
Posted by: Tom Wingfield on June 14, 2007 12:03 PMTom beat me to it, but "distance" between dates has no meaning... you mean "duration" or "time"?
Sorry... my inner pedant coulnd't be restrained.
EI
Posted by: Earnest Iconoclast on June 14, 2007 1:02 PMThank you, that's very cool.
When I worked in aerospace manufacturing we used to use circular plastic "date finders" that looked like this
http://www.identity-links.com/date-finder-calendar-card-p-4722.html
We would often know the cycle time to make parts or assemblages and once we knew the start dates we would use the date finder to calculate the finish dates.
Posted by: Reid Farmer on June 14, 2007 2:03 PMmost software packages, which I believe includes Excel and I know includes Matlab, will have a function that converts any date into a number. It is then easy to calculate differences between any 2 dates.
Posted by: lannychiu on June 14, 2007 3:51 PMheh, Yancey, I'm a shade over 15,000 myself...
so lemme see, I want to launch a resource hog like excel, and put in the date and all that, or launch a website from favorites, drop the numbers and go...
what is the matter with you peoples? still using a slide rule to figure out resteraunt tips?
so, Megan, I'll bet you can get a little script for your phone, or for the desktop... so you don't need the connection... oops, more overkill, sorry. :D
Posted by: D on June 14, 2007 5:45 PMgeoff - on the other hand dealing with java's rococco date functions is probably the most pain in the ass aspect of that language.
Posted by: will on June 17, 2007 5:19 PMI've often found timeanddate.com handy both in my job as a litigator and in my blogging, just for the ability to quickly bring up the day of the week of a particular date in the past.
Posted by: Crank on June 18, 2007 12:13 PMNot just for professional reasons...
Occassionally, I will throw a surprise 10,000 (or 20,000) day birthday party for a friend. It's a little geeky but it always surprises them. No gifts, no fuss, just fun! We've used Excel in the past and it works fine too.