Subscribe Bookmark

Community Manager


Jun 23, 2011

They Say It's Your Birthday...

Today is a special day for a colleague. Happens every 365 days.

A good friend here is 1388534400 today. At least that's what JMP tells me when I put her birthday in one column and today's date in another and then calculate the difference.

You see, JMP stores dates as the number of seconds since midnight on January 1, 1904. So today's date, October 26, 2009, is 3339360000 as far as JMP is concerned.

Fortunately, JMP has a host of built-in functions to help deal with dates in this format. See the whole list in the Formula Editor under the Date Time category.

One very helpful class of these functions are the In XXX() functions where XXX is a time unit. These functions return the number of seconds in the time unit specified. For example, In Minutes(1) returns 60. That is, there are 60 seconds in 1 minute.

These functions come in handy for converting JMP's seconds-based dates to something more readable, like years. You do that by dividing a number of seconds by In Years(1):

To save my friend's dignity, I'll let you use that formula to figure out how old she is.

I hope that she has a great day.

Community Member

John Neumann wrote:

I always thought the time functions were oddly (perhaps even misleadingly or confusingly) named. "In Years()" sounds like something to convert to years, rather than from years into seconds. The help and manual descriptions don't make it as clear as what you've written above. I had to spend some time experimenting to figure out what was going on.

Community Member

Diana Levey wrote:

My friends have certainily made me appreciate 44 today. It sounds quite young compared to the 1388534400 Jeff came up with. And it beats Jon's 2,296 weeks too! Now I'm thinking 44 sounds positively young! Thanks guys!

Community Member

Jon Weisz wrote:

She is 2,296 weeks old!

Article Tags