none
datetime format error FIM 2010 R2 RRS feed

  • Question


  • Hi Experts,

    I am getting employee EndDate in a file wtih format yyyymmdd like 20140314.

    I am able to get the date in metaverse through 'HR File Inbound Rule' but error while exporting to
    FIM MA.

    After getting the error 'datetime format' error, I made the following rule but again the same error.

    Left(EndDate,4)+"-"+Mid(EndDate,5,2)+"-"+Right(EndDate,2)+"00;00"=>employeeEndDate

    Again the same error :(

    Please suggest.

    Thanks,
    Mann

    Wednesday, April 16, 2014 6:41 PM

Answers

  • Hi Mann,

    What you need to do is just flow Date onto FIM portal in correct format. I suppose the correct format would be which I also used to flow onto FIM Portal:

    Use "yyyy-MM-ddTHH:mm:ss.fff" .

    I hope this will help you. If yes, Please mark as answer.


    Thanks~ Giriraj Singh Bhamu

    • Marked as answer by Mann.Cool Thursday, April 17, 2014 5:55 AM
    Wednesday, April 16, 2014 11:31 PM

All replies

  • Hi Mann,

    What you need to do is just flow Date onto FIM portal in correct format. I suppose the correct format would be which I also used to flow onto FIM Portal:

    Use "yyyy-MM-ddTHH:mm:ss.fff" .

    I hope this will help you. If yes, Please mark as answer.


    Thanks~ Giriraj Singh Bhamu

    • Marked as answer by Mann.Cool Thursday, April 17, 2014 5:55 AM
    Wednesday, April 16, 2014 11:31 PM
  • Thanks Giriraj!

    Would following formula work?

    Left(EndDate,4)+"-"+Mid(EndDate,5,2)+"-"+Right(EndDate,2)+"00;00;00;00"=>employeeEndDate

    Thanks,
    Mann
    Thursday, April 17, 2014 3:12 AM
  • It worked Giriraj!

    Answered marked yes :)

    Thanks Again!

    -Mannn

    Thursday, April 17, 2014 5:55 AM