Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Valued Contributor III

Limit dates in Oracle

I have a table in oracle db where the data is till 4th june 2018 but i want to load data till previous month last date so am using this condition in select

Where to_number(to_char(SURVEY_DATE,'ddmmyyyyhh24miss'))<'$(vMaxDate)'

vMaxDate is having 01062018000000

this is not working.

Any other idea?

2 Replies
Contributor III

Re: Limit dates in Oracle

Can you post your script?

did you try hard coding value instead of variable


Where to_number(to_char(SURVEY_DATE,'ddmmyyyyhh24miss')) < 01062018000000

then check value of variable in text object.


Honored Contributor

Re: Limit dates in Oracle

May be this,

Where to_number(to_char(SURVEY_DATE,'ddmmyyyyhh24miss')) <


Or check the vMaxDate variable.