topic Facing issue with date field in QlikView

Facing issue with date field

chinnu123 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 07 Nov 2017 07:13:44 GMT

Try with Floor function..

prma7799 — Tue, 07 Nov 2017 07:15:01 GMT

Please check this

jyothish8807 — Tue, 07 Nov 2017 07:17:58 GMT

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,