L3 Sprint 1 2.2 Baseline Financial Forecast csv file upload

Hi,

I am unsure what is going on with my time settings. I have tried every single way to format the time and date but did not work.

My time is set as

This is my Module looks like

This is my csv file date column and format looks like

This is my mapping and time format looks like

What format should I use that would upload properly?

Thanks,

Accepted answers

All sorted. I just had to change the excel file format

Look at the dates in csv vs how you mapped them…MM/DD/YYYY vs DD/MM/YYYY

Hi Rob,

I have changed the date format but still getting errors

When you open the csv, there should be a year for the date. What is the format of the column and why is it not rendering the year?

When I opened the CSV file, the date is DD/MM/YYYY as shown in above image

Sorry, I meant MM/DD/YYYY

All sorted. I just had to change the excel file format

Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
Action fails via cloudworks but works manually
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…