RangeDateEnd ( aRange, aYear )
Calculates the end date for a range based on value list.
Average rating: 4.4 (35 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Use with RangeDateStart function. A global start and end date calculated with this function can be used to filter a portal, choose report dates, etc.
Note: The end of "This Quarter" is defined as the current date...assuming there are no date values beyond it.
Call with values from value list:
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.