[RESOLVED] Getting the Next Month

[tuber]

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

[tuber]

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"
;