First Year of a month identification
In my Level 2 Supply Chain Lowel Bolin model I have multiple Time Settings module.
SYS00 Time Settings by Month
SYS01 Time Settings By Week
SYS02 Time Settings by Year
SYS03 Time Settings by Half Year
So, I have question regarding Weeks and Months. My SYS01 Time Settings By Week has
(Jan)Week 1 FY 20 - 12/29/2019-1/4/2020
(Jan)Week 2 FY 20 - 1/5/2020-1/11/2020
(Jan)Week 3 FY 20 - 1/12/2020-1/18/2020
(Jan)Week 4 FY 20 - 1/19/2020-1/25/2020
(Feb)Week 5 FY 20 – 1/26/2020-2/1/2020
I want to be able to identify thru a number (1,0) or Boolean the first week of each Month. So if using a Boolean I would mark Week 1 FY 20 as True and all other weeks in Jan 2020 as False. I would then mark Week 5 FY 20 as True and all other weeks in Feb 2020 as False…is this doable?