Import Action Error

Question

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.

Yash1 · Answer

Hi @Ankur.Sonthalia ,

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

jasonblinn · Answer

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

Jitendra.Vishnolia · Answer

@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)