Filter Query by date

[Serhiy-Nazarov]

Hello there! Could you help me to create query with dynamic filter by date. It should looks such as filter by ID.
For example,

SELECT * FROM "billings"
WHERE "billings"."id" = {{billing_id}}

In this case I'll see the dropdown filter by billing_id

But if I do this one

SELECT * FROM "billings"
WHERE "billings"."date" = {{billing_date}}

In this case I can see only text input without dropdown. Is it possible to make dropdown for select date from the list?

Thanks!

[omohokcoj]

@Serhiy-Nazarov hey hope this helps:

[Serhiy-Nazarov]

@omohokcoj it's great! Thanks!
But I want to have dropdown with a list of dates. Not datepicker.
If I select "reference" input type I can't select as a source a different query. Do you have any idea?

[omohokcoj]

@Serhiy-Nazarov currently the only way to achieve something similar is by using the predefined selector values:

Those selector values can be converted to timeframes in SQL - for now it's not possible to populate selector values from other query.