June 13, 2007

silhouette3.JPG From the desk of Jane Galt:

That's useful

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 | Technorati inbound links
Comments
Posted by: Cisco on June 13, 2007 5:28 PM

I think this is slightly more useful for journalists: http://www.weirdconverter.com/

Posted by: jim` on June 14, 2007 2:14 AM

Useful for market speculators as well.

Thanks Jane!

Posted by: per on June 14, 2007 3:10 AM

I'm probably missing something, but what does this do that cannot be done by subtracting two dates in Excel?

Posted by: Tim Worstall on June 14, 2007 5:18 AM

I'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: Dave on June 14, 2007 6:58 AM

Use Excel to build a template. Use some of the mathematical and logic skills which got you into U. Chicago Business School!

Posted by: Geoff Shotts on June 14, 2007 8:24 AM

Date 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: Tom Wingfield on June 14, 2007 12:03 PM

'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: Earnest Iconoclast on June 14, 2007 1:02 PM

Tom 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: Reid Farmer on June 14, 2007 2:03 PM

Thank 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: Yancey Ward on June 14, 2007 2:22 PM

Oh, crap! I will be 15,000 days old on July 27th.

Posted by: lannychiu on June 14, 2007 3:51 PM

most 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: D on June 14, 2007 5:45 PM

heh, 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: will on June 17, 2007 5:19 PM

geoff - 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: Crank on June 18, 2007 12:13 PM

I'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: Kim on June 18, 2007 5:24 PM

Not 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.

Comments are Closed.