I have a report with a dropdown month field.

I need to filter the report to only show records for the current month

I have tried:

Renewal_Month == zoho.currentdate.getMonth()

Renewal_Month == zoho.currentdate.toString("MMMM")

I also created a formula field that is input.Renewal_Month and tried both above option with the formula field.

None of them work.

How do I get this report to filter buy current month