When filtering in a date column, it shall be possible to enter a date range.
E.g. user wants to see all appointments beginning from May 23 und Dec 15 of the year 2020, he may enter something like "2020-05-23 ... 2020-12-15" in the criteria field of the column and the getSql() will accomplish a query like (date >= '2020-05-23' AND date <= '2020-12-15').
When filtering in a date column, it shall be possible to enter a date range.
E.g. user wants to see all appointments beginning from May 23 und Dec 15 of the year 2020, he may enter something like "2020-05-23 ... 2020-12-15" in the criteria field of the column and the getSql() will accomplish a query like (date >= '2020-05-23' AND date <= '2020-12-15').