Vam1992
Occasional Contributor

Error in 7.2.3 lesson invalid date

I gor struck while importing .csv file into SYS08 emplyee details module i am getting invalid format error .please help me out on this

1 ACCEPTED SOLUTION

接受的解决方案s
Misbah
Moderator

@Vam1992

Yes it has to be done in the importing mapping. Go to this window and click on this checkbox

Misbah_0-1615976107266.png

Select YYYYMMDD option and you should be able to map it

Misbah_1-1615976180347.png

View solution in original post

7 REPLIES7
Misbah
Moderator

@Vam1992

Looks like the format of the dates in Mapping is not done correctly. It should be YYYYMMDD

Vam1992
Occasional Contributor

Then i have to change in model
Misbah
Moderator

@Vam1992

Yes it has to be done in the importing mapping. Go to this window and click on this checkbox

Misbah_0-1615976107266.png

Select YYYYMMDD option and you should be able to map it

Misbah_1-1615976180347.png

Vam1992
Occasional Contributor

Tq soo much it helped
Megha27
Contributor

Thanks for your response on this. Curious as to why it is only YYYYMMDD that works here and MMDDYY is not acceptable?

srikanthkamath
Contributor

Hi@Megha27

This is as per the data you received in your source file. Since the format is YYYYMMDD in your file for start date and end date, you are asking anaplan system to consider this format.

Regards,

Srikanth

Megha27
Contributor

Thank you@srikanthkamath