Brian Dunning's FileMaker Custom Functions

IsDateInRange ( TestDate , LowerLimit , HigherLimit )

Determines if a given date falls between two reference dates.

  Average rating: 4.0 (34 votes) Log in to vote

Ibrahim Bittar Torres   Ibrahim Bittar Torres
Eikonsys, S.A. de C.V.
http://www.eikonsys.com

Share on Facebook Share on Twitter

  Sample input:
IsDateInRange ( 1/15/2006 , 1/1/2006 , 1/31/2006 )
  Sample output:
1

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

This function is useful to determine if a given date falls between other two. Its benefits become evident when you have dynamic dates based on calculations and need to save space in the calculation.

For example I use it in an aging report where I need to determine if the invoice date falls between a 0, 30, 60, 90 or 90+ days due and those ranges are configurable by the user:

If ( IsDateInRange ( InvoiceDate , Get ( CurrentDate ) + Range 1 , Get ( CurrentDate ) + Range 2 ) , Total Amount , 0 )

 

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.