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.