Convert Date with Week Format to Last day of month with a Date Format

jk1nn1ck_*20973
jk1nn1ck_*20973
in Modeling

Hi,

 

My model's Model Calendar - Calendar Type is set to 'Weeks: General'. I have a module with a column of dates and the Format is set to Week. 

 

In another column with Format set to Date, I'd like to write a formula that will take the date from above, lets say it's 9/2/2019, and output as the last day of the month in date format, so -  9/30/2019.

 

In Excel, I would just use =EOMONTH(9/2/2019) to get 9/30/2019, but the time dimension of Anaplan is limiting in this way.

 

Is writing a formula like this possible since my model calendar is set to Weeks: General and the date I'm pulling from has a format of Week?

 

Thanks in advance,

Tagged:

Best Answer

  • nathan_rudman
    nathan_rudman
    Answer ✓

    Hi,

     

    it would be easier with a monthly calendar but we it still easy achievable  with the DAYSINMONTH formula

     

    You can do like this:

    end of months from weeks.png

    (the first screenshot is by days but it is the same with weeks as below)

     

    end of months from weeks blueprint.png

Answers

Categories