Thx for the genius comment. I think I'm just hooked in brain teasers.
Ys, that one is more tricky. Let me think.
Here is one solution that should work, but not tested.
Make a new formula date field called [Date Plus 1 Year]. The formula will be
AdjustYear([My Date Field], 1)
So now we have last year's date for the MM DD part, but with the current YYYY.
Then filter where
all of
[Date Plus 1 Year] is during the Current Year
[Date Plus 1 Year] is before Today
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------