First Year of a month identification

Options
bolinl1
bolinl1 Member, ALL USERS, Community Member, Certified Model Builder Posts: 2 New Contributor
in Planning & Modeling

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?

Tagged:

Comments

  • bolinl1
    bolinl1 Member, ALL USERS, Community Member, Certified Model Builder Posts: 2 New Contributor

    But don't I then have to do this every time I move out another year?  

Categories