Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
gautik92
Specialist III
Specialist 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
big_dreams
Creator III
Creator III

Can you post your script?

did you try hard coding value instead of variable

like

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


then check value of variable in text object.


Regards,

balabhaskarqlik

May be this,

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

to_number('$(vMaxDate)','ddmmyyyyhh24miss')

Or check the vMaxDate variable.