age ( date1 ; date2 )
Rate this function: Average rating: 2.8 (8 votes)
Discuss this Custom Function
Winfried Huslik, Huslik Verlag GmbH
http://fmdiff.com
Calculates the number of years, months, and days between any two dates
Sample Input:
| age ("7/27/1980" ; "7/26/2006" ) |
|
Sample Output:
25
10
30
25 years, 10 months, and 30 days |
|
Description:
This calculation takes into account different days in a month as well as leap years and negative distances. The result is provided as a line separated list containing Years, Months, Days. To access these results use LeftValues (), MiddleValues (), and RightValues () respectively. Use at your own risk.
<br />This formula is meant as a replacement for the one given at <a href="http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=5532&p_created=1129657697&p_sid=-ERH76bi&p_lva=&p_li=&p_topview=1">FileMaker Custom Help</a><br />
Address comments to agecalc@fmdiff.com.<br />Download an example file at <a href="http://fmdiff.com/fm/agecalc.html">http://fmdiff.com/fm/agecalc.html</a>.
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:
|
Newest Custom Functions:
| 1. |
GetResultParameter( ParameterName ) |
| |
(Wed, Aug 25, 8:32am) |
| 2. |
GetListParameter ( ParameterList ; ParameterName ) |
| |
(Wed, Aug 25, 8:25am) |
| 3. |
Standard_Deviation( Field ; MaxLoopCount ; StartIndex ; StdDeviation ; ArithMeanValue ) |
| |
(Tue, Aug 24, 10:57am) |
| 4. |
Arithmetic_Mean ( Field ; MaxLoopCount ; StartIndex ; MeanValue ) |
| |
(Tue, Aug 24, 10:51am) |
| 5. |
Age ( Birth; theDate; Format ) |
| |
(Fri, Aug 20, 9:50am) |
| 6. |
Power ( x ; y ) |
| |
(Thu, Aug 19, 5:56am) |
| 7. |
portal.rowCount ( _name ) |
| |
(Sun, Aug 15, 2:41pm) |
| 8. |
PostPer_Day ( Post; startDate ; finishDate ; returnType ) |
| |
(Sat, Aug 14, 2:02pm) |
 |
|
Don't know why the vote is so low on this function?
It's the only age function that calc's the date correctly.
Thank you
Darren, UK
July 13, 2010 2:31am