This content has been marked as final. Show 3 replies
You can try this
(Cast(MONTHNAME(date) as Char) = 'Apr'
Try selecting "Apr" from the filter choice, instead of typing "Apr". There could be formatting issues.
Please use CAST as below and select the value from filter.
CAST( MONTHNAME(date) as CHAR)
Hope this would help you.