Hi,
until the last 9.6 versions, the content of date fields was passed in a control app in the format “2022-01-26” ({DateFrom}). This could be used to feed an SQL query:
AND (date BETWEEN ‘" . {DateFrom} . "’ AND ‘" . {DateTo} . "’).
However, with version 9.7 the date is passed in the format “26012022”. This is completely wrong and must be corrected.