comparison of dates

[QlikBeginner1]

Hi,

I essentially have 4 date fields, 

datestart1

dateend1

datestart2

dateend2

I am trying to create a flag which essentially sets the flag as '1' where datestart1 and dateend1 is within datestart2 and dateend2.

e.g.

datestart1: 01/04/2019 

dateend1: 01/04/2020

datestart2: 01/03/2019

dateend2: 01/03/2021

This would occur as a Flag of '1' as datestart1 and dateend1 is within datestart2 and dateend2. However,

datestart1: 01/04/2019 

dateend1: 01/04/2020

datestart2: 01/03/2019

dateend2: 01/03/2020

This would occur as a Flag of '0', as the datestart1 and dateend1 is not within datestart2 and dateend2. 

Is there a function within Qlik that allows me to do this? or what would be the best way to do this?

thanks

[pradosh_thakur]

You can use a simple if claue to do this. 

iF(datestart1>= datestart2 and datestart1<= dateend2 and dateend1>= datestart2 and dateend1<= dateend2 ,1,0) as Flag