Brian Dunning's FileMaker Custom Functions

ElapsedbyIno ( StartDate ; EndDate ; Type )

For rest of us ISO: D M Y or ANSI: Y M D

  Average rating: 4.2 (36 votes) Log in to vote

Aleksandar Rubeša   Aleksandar Rubeša
Q.com doo
http://q-com.hr

Share on Facebook Share on Twitter

  Sample input:
ElapsedbyIno ( 1/1/2000 ; 15/7/2004 ; 1 )
  Sample output:
4 Years 6 Months 13 Days

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

For rest of us I little beet recreated Lee Smiths function: Elapsed ( ISO D M Y or ANSI Y M D with changeable Date Names for Y M D )in 6 languages
(sixth - 6th can be changeable).

Input:
StartDate = Date
EndDate = Date
Type: ANSI (Default) or ISO
Output: Text

Recreated by Ino

P.S. Semple file : FMForums » Main Index » Forum Index » Advanced Features & Functions » Custom Functions »
ElapsedbyIno

http://www.fmforums.com/forum/showtopic.php?tid/171907

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.