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

    Last Month as just month Name

    Neil Deeley



      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!