Skip to main content
Question

Using a date picker input box for a component filter

  • December 1, 2025
  • 2 replies
  • 30 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

2 replies

julia.bauer
Level 9
Forum|alt.badge.img+6
  • Level 9
  • December 12, 2025

Hello ​@denise.kruge12 , I have had a similar problem with a variable in a view. I needed the ADD_DAYS function paired with the variable. For me this syntax worked {t ${my_start_date_variable}}.

 

BR

Julia


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

Thank you. I managed to solve this one, see link to documentation:

Date Picker (celonis.com)