Filter Charts With Dates Oracle Apex

Question

I am trying to add filters to my charts. How can I add a filter if my input is dates? For example I want to be able to filter to just the year of 2022 or I want to be able to look between the days of XX/XX/XXXX-XX/XX/XXXX

My input type is date but I only know how to filter by names at the moment using a command like this:

Paint_shop = :P9_Select_Shop

Answer 1

For years:

where extract(year from date_column) = 2022

For dates (as Apex items' datatype is char, presuming you set format model to dd.mm.yyyy):

where date_column between to_date(:P1_DATE_FROM, 'dd.mm.yyyy')
                      and to_date(:P1_DATE_TO  , 'dd.mm.yyyy')