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

jk1nn1ck_*20973

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,

ddddd_53227.jpg

Accepted answers

nathan_rudman

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

All comments

nathan_rudman

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

jk1nn1ck_*20973

Thanks Nathan, this worked for me!

nathan_rudman

do you know this page ?
https://help.anaplan.com/anapedia/Content/Calculation_Functions/CF_All_Functions.htm?cshid=1550
quite useful to find what you need

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…