Years in Business Calc

[Dr. Evil]

I wish to have a calculation field result in Years, Months and Day in business. I have a date field for date founded.

Anyone have a niffty calc to do this?

Of course, thank you in advance!

[Lee Smith]

This is just like a Age calculation, which you can find several examples by searching the Forum. The Custom Functions has at least one, which I labeled Elapse ( StartDate ; EndDate ) and can be found Here.

You do not have to use a custom function for this calculation to work.

HTH

Lee

[comment]

I'd suggest you follow the links here:

http://www.fmforums.com/forum/showpost.php?post/213906/

[Dr. Evil]

Thank you for your help.

I was having issues using the Get (Current Date) function.

I found a solution that seems to work well for me.

I got it from Database Pros:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000773

If anyone sees an issues with the linked solution please feel free to comment.

Again, THANK YOU ALL!

[comment]

I have no issue with this solution or another, but with the concept itself. There is no such thing as 'years, months and days'. It's a meaningless phrase. The number of days in a month is not constant, so no one can take a period of time and divide it into x months and y days in any meaningful way.

In this thread I have made a bet with myself that I will break any calculation of the "years, months, days" type. Of course, that too is a meaningless promise, because how can you prove that something meaningless is incorrect?

Nevertheless, consider these results of the solution you have chosen:

From Jan 31, 2007 to Mar 1, 2007: 0 Years, 1 Month, 1 Day;

From Jan 30, 2007 to Mar 1, 2007: 0 Years, 1 Month, 1 Day;

From Jan 29, 2007 to Mar 1, 2007: 0 Years, 1 Month, 1 Day;

From Jan 28, 2007 to Mar 1, 2007: 0 Years, 1 Month, 1 Day.

How can that be? The period is growing by one day in each step - yet the difference remains the same!

[Dr. Evil]

Ah, I gottcha.

Interesting topic, thanks for the thread link, I enjoyed the read.

It's a good thing I don't need this calc to be "precise" or I would go mad.