Skip to main content
Question

Using a date picker input box for a component filter

  • December 1, 2025
  • 0 replies
  • 9 views

denise.kruge12
Level 7
Forum|alt.badge.img+19

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