I created a custom report and would like to allow an user to filter it for some Deadlines.
The deadlines are formatted via a SQL-View.
But this way it is not possible to filter, with the “filter type” option under “Custom reports”.
I tried using the “display type” option in the custom report creation, but this is pointless, because it is automatically formatted in the following format: “yyyy-dd-mm”, the default format in our country is “dd.mm.yyyy”
My question is: how can I set it up to show me a correct date format and how will I be able to filter it?