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
Eikonsys, S.A. de C.V.
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 )
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.