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 - Show more from this author
Eikonsys, S.A. de C.V.
http://www.eikonsys.com

Sample input:

IsDateInRange ( 1/15/2006 , 1/1/2006 , 1/31/2006 )

Sample output:

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

Let ( [ LowerDate = Get ( CurrentDate ) + LowerLimit ; 
          HigherDate = Get ( CurrentDate ) + HigherLimit ] ; 

If ( TestDate ≥ LowerDate and TestDate < HigherDate ; 1 ; 0 ) )

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

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

IsDateInRange ( TestDate , LowerLimit , HigherLimit )

Comments

Support this website.

Support this website.