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 doo

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).

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 »



Log in to post comments.


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

Under construction. Email me your wish list for improvements.