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
CodePudding user response:
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')