Multiple conditions for a date range on one flag ?

[Domino1]

 Hello, 

Fiscal Year start is : Oct 1  and ends : Sept 30 

Requirement is need to flag all dates that is within Sept 30 - Oct 1 regardless of year. 

If there is a 9/30 and 10/1  between  StartDate  and EndDate - need to flag it.

Tried many variations of  if statements such as below and no luck. 

If ( StartYear < EndYear  and  StartMonth <10  and EndMonth >10 , 0, 1)  

See attached file .

[vikasmahajan · Accepted solution]

Hi

You need to implement master calendar see below script:

https://community.qlik.com/t5/QlikView-Documents/Fiscal-and-Standard-Calendar-generation/ta-p/148082...

Regards

Vikas