AnsweredAssumed Answered

Help with getting date range

Question asked by danlee on May 1, 2015
Latest reply on May 2, 2015 by philmodjunk

Title

Help with getting date range

Post

I have a field, MPQuota, with calculation:

Let ([
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.

Thank you

Outcomes