Good morning,
I need to create a date filter for the start date on a graph, and the date is a user input, so I create a Date Picker as input box and save it as a variable.
I struggle with the PQL in my graph FILTER PQL statement:
FILTER “table”.”datecolumn” >= {d ‘${my_start_date_variable}’}
But I get this error message

How do I adjust my PQL to get the date format correct? The date picker has a standard format that cannot be changed.
I also tried this, and it does not work:
FILTER “table”.”datecolumn” >= ({d '${my_start_date_variable}'}, FORMAT ( '%Y-%m-%d'))
Any assistance will be appreciated.
Thank you,
Denise