Add new Date Field - Periods and defined dates

[idodel]

Hi pros,

I need to add a new field to the model that contain dates of different periods in the Fiscal Year between June to May.

 Example:  

FY	Period	Start Date	End Date
FY21	1	31/05/2020	27/06/2020
FY21	2	28/06/2020	25/07/2020
FY21	3	26/07/2020	22/08/2020
FY21	4	23/08/2020	19/09/2020

I have already in the model the next table that contain:

If I will do left join, there will be much of duplicate and wrong info.

How can I add this time periods in a suitable way to the model ? So there won't be duplicate values.

Thanks

Ido

[MayilVahanan · Accepted solution]

Hi @idodel 

Try with intervalmatch concept

https://mindmajix.com/qlikview-intervalmatch