Forum Discussion
My suggestion would be to make a report-formula of type checkbox that checks if the date is the most recent month or one year prior and then user the report formula as your filter.
So for example the formula might be like:
var date current = AdjustMonth(FirstDayOfMonth(Today(),-1);
var date prior = AdjustMonth($current,-12);
$current = [Date in your record] or $prior = [Date in your record]
Then in your filter you just find that report formula field and set it equal to 1 as the value since the formula will return 1 or 0 as true/false.
------------------------------
Chayce Duncan
------------------------------
Thanks again, Chayce. Worked beautifully. I had to add a close parenthesis after the the first one, before the comma. You would obviously see that if you were doing this formula, so that's mainly for anyone else that comes across this thread in the future.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------