L3 Sprint 1 2.2 Baseline Financial Forecast csv file upload

sakand

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,

S

sakand

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

rob_marshall

@sakand

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

sakand

Hi Rob,

I have changed the date format but still getting errors

rob_marshall

@sakand

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?

sakand

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

sakand

Sorry, I meant MM/DD/YYYY