2 Replies Latest reply on Jul 14, 2013 8:55 PM by danlee

    Find record for previous month

    danlee

      Title

      Find record for previous month

      Post

           I have a script that will give me a 1 if any of the fields date falls within current month.  How can I change it for finding dates that falls from previous month?

           Here is the script for current month.  Just need it to change to give me a 1 for dates that falls in previous month.

      Let ([
      SummaryYrMo = Year(StrategyDate) & Right ("0"&Month (StrategyDate); 2);
      Today= GetAsDate (Get(CurrentHostTimeStamp));
      TodayYrMo = Year (Today) & Right ("0" & Month (Today); 2)];
            
      Case (TodayYrMo = SummaryYrMo; 1; 0)
      )