2 Replies Latest reply: Jun 21, 2016 2:18 AM by Hasvine Dhurmea RSS

    Dynamic filter in Nprinting by month

    Hasvine Dhurmea

      Hello All,

       

      I need to create a filter in Nprinting to select the last 3 months.

       

      To calculate the current month I am using the below expression:

       

      =Month(now()) which returns the value June.

       

      However, I do not get any value using =Month(now()-1) and when I try this expression =Month(now())-1 it gives me 5 as the result.

       

      I need an expression which will return the value of May and April.

       

      Any idea?

       

      Many Thanks,

       

      Hasvine