Internal Error when using date filter on custom reports

#1

When I tried to make a Custom Report and by using any condition related to date and select “between” and if I instert any date range this error appears

2020-06-09 (2)
2020-06-09 (2)1440×900 178 KB
2020-06-09 (1)
2020-06-09 (1)1440×900 170 KB

#2

What happens when you change the first dates ?

In the example you showed, the report select transactions dated 9/6/2020, so it probably has no transactions to use for the selection by the Payment or Receipt / Date field

#3

the same error appears

#4

I can reproduce this - it seems like a bug
Custom report with no Where clause (note Payment or Receipt/Date has a few records with data

image
image664×653 18.6 KB

Report
image
image792×614 21.2 KB

Add a where clause

image
image724×624 17 KB

give Internal error
image
image1191×560 31 KB

#5

Thanks. Fixed in the latest version (20.6.80)

#6

Sorted - at least for my custom report