How to Get Correct Month in a Weekly Time scale Model

Options
AnkitGupta
AnkitGupta Member, ALL USERS, GroupMember, Certified Master Anaplanner, Employee, Certified Model Builder Posts: 5 Certified Master Anaplanner
in Planning & Modeling

I have a 4-4-5 Weekly Model. Details below

 

Time ScaleTime Scale

 

 

I wanted to get the exact month for a particular date. Details below

 

 

Formula?Formula?

 

Period(Valid from) for 5/31/2020 is giving the month as Jun 20 and not May 20. I understand that it will fall in a week which will be in Jun but how to get the correct month from this date?

Thank you.

 

Tagged:

Comments

  • AnkitGupta
    AnkitGupta Member, ALL USERS, GroupMember, Certified Master Anaplanner, Employee, Certified Model Builder Posts: 5 Certified Master Anaplanner

    Thank you @anikdas that was quick!

    It works, thanks a lot for the help!🙏

Categories