4 Replies Latest reply: Nov 19, 2013 2:55 AM by Juan Gerardo Cabeza Luque RSS

    Last Three Months

      Hi,

       

      I'm trying to get the Month names for last three months.

       

      I can get the current month name using the following expression:

      Month(Today())

      it returns me Nov.

      But when I try using Month(Today())-1 it returns the value 10 instead of Oct.

      To solve this issue I tried using Monthname(month(Today())-1) but it returns the value 'Jan 1900' instead of converting the '10' in Oct.

       

      How can I get the previous month name?