What's wrong with this?
="MTD: "+MonthName(Month(Globals.ExecutionTime)-1)
I am trying to return the name of the month that is one month prior to the current month.
Will the above work? Will it work in January, too, where the previous month can't be calculated as the month number -1? Example: the month prior to March can be calculated as 3-1. But in January 1-1 doesn't equal 12.
Thanks in advance!
="MTD: "+MonthName(Month(Globals.ExecutionTime)-1)
I am trying to return the name of the month that is one month prior to the current month.
Will the above work? Will it work in January, too, where the previous month can't be calculated as the month number -1? Example: the month prior to March can be calculated as 3-1. But in January 1-1 doesn't equal 12.
Thanks in advance!