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