4 Replies Latest reply: Apr 28, 2015 5:31 AM by Neil Deeley RSS

    Last Month as just month Name

    Neil Deeley


      Hi,

       

      I'm setting some variables in my load script to bring back month names:

       

      SET tThisMonth = Month(Today());

      SET tLastMonth = Month(Today())-1;

       

      However, whilst the first variable returns Apr, the second returns 3. I need this variable to be just the month name, as the data I am evaluating has the amount in one column and the month name for that amount in the next. I've tried MonthName but this also returns the year.

       

      Any help gratefully received!

       

      Cheers

      Neil