Need to increase calenderweekid by 1 if calenderweekid is same for 2 fiscal weekoffset

pk11 — Fri, 15 Apr 2022 09:39:04 GMT

Hi Team,

As per attached excel I Need to increase calenderweekid by 1 if calenderweekid is same for 2 fiscal weekoffset

For example

For Fiscalweekoffset 11 and 12 the calenderweeknumberid 202226,

My requirement is for fiscalweekoffset 11 the calenderweeknumberid should be 202226,

and for fiscalweekoffset 12 the calenderweeknumberid should be 202227.

just for information, Since fiscal year starts from jul1 2022 to jun 30 2023 that's why new fiscalweekoffset is added.

Regards

Prashant

topic Need to increase calenderweekid by 1 if calenderweekid is same for 2 fiscal weekoffset in App Development