Discussion board where members can get started with Qlik Sense.
Can any one please help me on below requirement.
I have a oracle table like below in qlik
to_char(ap.date,'DD/MM/YYYY') as date,
from account ap
where to_char(ap.date,'DD/MM/YYYY') in '31/07/2017';
In the above table at where condition i have to apply where ap.date <= '31/07/2017' in static way dynamic method is not required.just for testing purpose.
Please help me how to write that oracle syntax at select statement.
Thanks in advance.
Go to Solution.
where ap.date <= TO_DATE('31/07/2017', 'dd/mm/yyyy');
Thanks for your reply sunny below one is also working.
where to_char(ap.date,'DD/MM/YYYY') <= '31/07/2017';