Getting error while creating filters on a field in Jasperserver v5


After dropping respective fields in ad hoc view, I tried creating filters over them but getting error (see attachment). How to get around with this?


error : Cannot evaluate the following expression: betweenDates(report_1.start_date, d'2010-12-06', d'2013-02-28')

gnyanendra's picture
Joined: Dec 3 2010 - 12:25am
Last seen: 6 years 7 months ago

1 Answer:


Can you explain more what type of filter it is. I think the domain you are using has a problem with the date range.

kpant's picture
Joined: Sep 18 2009 - 7:23am
Last seen: 2 years 4 months ago

I had named the domain as 1_domain and later changed it to domain_1 which worked!
I checked with the date results, there were no out of format entries of non-existing dates.

gnyanendra - 7 years 5 months ago