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!
Solved! Go to Solution.