Help with getting date range
I have a field, MPQuota, with calculation:
SummaryYrMo = Year(Date_Meal Plan) & Right ("0"&Month (Date_Meal Plan); 2);
Today= GetAsDate (Get(CurrentHostTimeStamp));
TodayYrMo = Year (Today) & Right ("0" & Month (Today); 2)];
Case (TodayYrMo = SummaryYrMo; 1; 0)
This gives me a "1" if the date for field Date_Meal Plan is in the current month. How do I change that to get the same thing for dates a month prior, 2 months prior, 3 months prior, etc. I will create separate fields for those calculations.