I tried everything the last hours, but nothing is working.
But know a team member found a solution.
I have to write the Date as a String with two aposthrope.
it also works with the time. You have to write:
Thank you for your help!
Now, I understood your question, you should actually use
Time <= TO_DATE($Variable', 'YYYY-MM-DD') here use whatever the format is there in your variable
Here is a picture from it. “Time” is the name of the column from a sql table.
The SQL Table
There is no function “to_date” only a function named “parseDateTime” .
I found this description:
But in my case, there is an error, listed below.