Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
chinnu123
Creator
Creator

Facing issue with date field

Hi Team,

OPEN_DATE >= TRUNC(TO_DATE( '01/10/2015', 'MM/DD/YYYY')) AND

OPEN_DATE <= TRUNC(TO_DATE( '05/31/2017', 'MM/DD/YYYY'))

I need to change the above format to qlik. can anyone help on this?

3 Replies
prma7799
Master III
Master III

Try with Floor function..

prma7799
Master III
Master III

Please check this

Date Conversion

jyothish8807
Master II
Master II

Hi Chinnu,

What is the format of OPEN_DATE and what is TO_DATE?

You may try like this:

Make sure OPEN_DATE is in the format of 'MM/DD/YYYY'. If not in the script convert it:

Load *,

DATE(OPEN_DATE,'MM/DD/YYYY') as OPEN_DATE

From <>


exp:

if(OPEN_DATE >='01/10/2015' and OPEN_DATE <='05/31/2017','Your requirment')

Br,

KC

Best Regards,
KC