Error in 7.2.3 lesson invalid date

Vam1992
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

Accepted Solutions
Misbah
Moderator

Re: Error in 7.2.3 lesson invalid date

@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 REPLIES 7
Misbah
Moderator

Re: Error in 7.2.3 lesson invalid date

@Vam1992 

 

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

Vam1992
Contributor

Re: Error in 7.2.3 lesson invalid date

Then i have to change in model
Misbah
Moderator

Re: Error in 7.2.3 lesson invalid date

@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

Vam1992
Contributor

Re: Error in 7.2.3 lesson invalid date

Tq soo much it helped
Megha27
Occasional Contributor

Re: Error in 7.2.3 lesson invalid date

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

SrikanthKamath07
Contributor

Re: Error in 7.2.3 lesson invalid date

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
Occasional Contributor

Re: Error in 7.2.3 lesson invalid date

Thank you @SrikanthKamath07