I tried to visualize it in the image.
I have a special data (lets say 22.02.2021) and i want to give back the answer "yes", if my currently selected CALENDAR WEEK is within the last 2 calendar weeks (red line) from my special date.
i tried something like:
if(special_date>=Date(MakeWeekDate(Year,CW,0)-14) and special_date<Date(MakeWeekDate(Year,CW,6)-7) and ,'Yes','No')
the date is always a fix data, it cant be changed! The CW and the year is variable and is based on a selection.
Any help is appreciated!