Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
ta_nihal
New Contributor

if between and condition equivalent for dates

hi everyone,

I'm trying to add an expression for new column contains ok or null according to condition

here is my condition

if (tarih between '31.07.2016' and '31.08.2016', 'ok', 'null') but it didn't work.

*tarih refers column name contains dates

how can I make it

thanks

1 Reply
mwoolf
Honored Contributor II

Re: if between and condition equivalent for dates

if(tarih>=date('31.07.2016' ) and tarih <=date('31.08.2016'),'ok','null')