Hi Anaplanners,
Need help with the following error:
Can you please let me know how to resolve this..? (See the pictures)
Thanks in advance,
Ankur Sonthalia.
Hi @Ankur.Sonthalia ,
No Pictures attached.
Thanks @Jitendra.Vishnolia,
@Ankur.Sonthalia can you please check for data consistency, as somewhere it is in format DD-MMM-YYYY and somewhere DD-MM-YYYY ( e.g. both the formats are present in the log shared by you i.e. 19-04-2013 and 07-Jan-2003)
You should Just be able to set the Time Pattern with Separators to D-M-Y as that will read 1 digit, 2 digits, or Name for Month.
This way:
12 = December
and
Dec = December
It seems to me as well, that it is a data inconsistency issue. You have 2 different formats for dates.
Can you try to have one date format, then create an appropriate date mapping and then try to load.
Feel free to update if you are still struggling.
Thanks,
Yash
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
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…
