[RESOLVED] Getting the Next Month
In our database there is a month field but it's a string. I need to run a report on this table for all records where it's the next month, this is a reoccurring report so I can't just say "May"
The dateadd returns 1-12.
Do I need to have a formula field and a CASE statement? Or would that even work because it would run until after the report loaded.
Any help would be great!
Thanks
Re: Getting the Next Month
Select Month(currentdate)
Case 1 : "February"
Case 2 : "March"
Case 3 : "April"
Case 4 : "May"
Case 5 : "June"
Case 6 : "July"
Case 7 : "August"
Case 8 : "September"
Case 9 : "October"
Case 10 : "November"
Case 11 : "December"
Case 12 : "January"
default: "January"
;