Spoiler (Highlight to read)I have monthly date as Jul 21, I want that to converted in last date of the month in 07/31/2021 format, is there a specific formula for the same?I have monthly date as Jul 21, I want that to converted in last date of the month in 07/31/2021 format, is there a specific formula for the same?

Month to Date Format - Anaplan Community

Write END(Date) as formula. If there is a time as a dimension then just END() would do

Misbah

Write END(Date) as formula. If there is a time as a dimension then just END() would do

Misbah

You can use End() function to get end date of the month

Thanks

Thanks for the help.

ADO import job invocation from Airflow.
Is there an ADO API endpoint that can be used to trigger ADO import job (from Airflow). As per Anaplan documentation, ADO import/export jobs can be triggered only via the console or can be scheduled (via process/workflow). Alternatively, is there a workaround if the ADO API is not Generally Available yet?
L3 Sprint 2, User Story 3.3 Q1 Quarter Allocation
Hi Community, It appears that values shown here for Q1 are assuming 29 days in Feb 25, when there are actually only 28. My values tie out for all Quarter values and all months shown from Apr 25 forward, and it's not possible for only a single quarter/finite range of months to differ with formula-driven values: Please…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…