FileMaker Pro Custom Functions

Search  |  List  |  Show Random  |  Upload  |  Add This to Your Site

age ( date1 ; date2 )

Winfried Huslik, Huslik Verlag GmbH
http://fmdiff.com

Calculates the number of years, months, and days between any two dates

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

digg this page | del.icio.us this page

Download the Custom Function Dashboard Widget for OS X Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions: 1. PVofFV ( FutureVal , Interest , Term )   (Sat, May 10, 6:52pm) 2. Edate ( thedate ; months )   (Sat, May 10, 5:21pm) 3. FormatDate( DatetoFormat )   (Thu, May 08, 6:05pm)

Custom Function Authors:
Link to all of your own custom functions on this site with the following URL:
http://www.briandunning.com/filemaker-custom-functions/results.php?author=Your Name Here