Add new Date Field - Periods and defined dates

idodel — Wed, 14 Apr 2021 10:20:38 GMT

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:

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

Re: Add new Date Field - Periods and defined dates

MayilVahanan — Thu, 15 Apr 2021 08:56:22 GMT

Try with intervalmatch concept