MagicDates ( range )
Gives you FM-Find Friendly date ranges based on User-Friendly input. Works great with the
Average rating: 4.3 (36 votes) Log in to vote
Andy Frazier - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
**Special thanks to Excelisys & the "Business Tracker" for the brilliantly simple way of calculating quarters.
Hal, Aiken, SC
Jun 10, 2010
|Very handy function!|
Doug Larsen, Mpls, MN
Sep 15, 2010
A very handy function but be aware that the parameter called ThisQuarter actually returns a date range that that would more accurately be called QuarterToDate.
For instance, if it is 8/15/2010 and you run the function using parameter "ThisQuarter" you would likely expect it to return:
But it actually returns:
PS. I couldn't find an email address for the author so he is unaware of the problem.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.