Convert Date with Week Format to Last day of month with a Date Format
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?