Filters not working

[baarathi]

I have a NPrinting Excel Report Template, I have applied filter on fields Company Name and MonthYear filters.

Field1: Company - Asant

Field2: MonthYear - 2018-Dec

The Company filter works fine. But the MonthYear filter does not seem to get applied?

[pradosh_thakur]

Is your month year date or string? you might need to use the evaluate option to make it work. How does your MonthYear looks like?

[baarathi]

@pradosh_thakur  Hi Pradosh,

My MonthYear Field has values in this format 'Dec 2018'

[pradosh_thakur · Accepted solution]

try below

1: add Dec 2018 as a string and check if you are getting the output

2: add date#('Dec 2018','MMM YYYYY')   as the evaluate option.

Let us know if any of above works

[Frank_S]

If  your month year  field is actually a 'dual' then you need to use 'numeric value is' rather than 'value is' when creating/configuring the filter in NPrinting. It could be that the data is numeric even if it appears as alphanumeric.

[baarathi]

@Frank_S Thank You. 

[baarathi]

thank you