Facing issue with date field

[chinnu123]

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?

[prma7799]

Try with Floor function..

[prma7799]

Please check this

Date Conversion

[jyothish8807]

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