4 Replies Latest reply: Aug 28, 2017 5:40 PM by James Williams RSS

    Rolling Calendar and IF Statement

    James Williams

      I have a rolling 13 month calendar that is used for several clients. However one client's data only starts in Feb 2017.

      I need an if statement so any months prior to Feb 2017 will not show (If RollingStartDate is < Feb 2017 ???.

      How do I add that to the below?

      Let vYear = Year(Today()-1);

      Let vPriorYear = Year(Today()-1)-1;

      Let vRollingStartDate = Date(MonthStart(AddMonths(Today()-1, -12)));

      Let vToday = Date(Today()-1);

       

      Thanks for the assist - Jim