Current Month Filter

[KHSDM]

Hi all,

I have a month field in my QVW, and I want to filter it in Nprinting to the current month. I've created a filter with that field and use the evaluate option, but I keep getting error when I run the task. It works if it is just the current year field.

What could be the cause of the error?

[pradosh_thakur]

Do a quick check please.

1: Just put the MonthName values as Feb once and run
2: Just put the MonthName values as 2 once and run

Let us know if this generates error.

[KHSDM]

Hi Pradosh,
It works if I put it as ='Feb'
It doesn't work if I put is a =2

[pradosh_thakur]

Try =text(Month(Today())) as evaluate value. I think it should work.