Error in 7.2.3 lesson invalid date

Options
Vam1992
Vam1992
in Modeling

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

Tagged:

Best Answer

  • Misbah
    Misbah
    Answer ✓
    Options

    @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

     

     

Answers

  • Misbah
    Misbah
    Options

    @Vam1992 

     

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

  • Vam1992
    Vam1992
    Options
    Then i have to change in model
  • Vam1992
    Vam1992
    Options
    Tq soo much it helped
  • Megha27
    Megha27
    Options

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

  • srikanthkamath
    srikanthkamath
    Options

    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
    Megha27
    Options
    Thank you @srikanthkamath

Categories