none
Difference in SQL and FIM EmployeeEndDate Time

    Question

  • Dear All,

    we are importing EmployeeEndDate from SQL to Portal. Employee end date set to 11/05/2018 01:40 PM but in Portal its showing 11/05/2018 07:10 PM

    Need Your Help!

    Thanks,

    Shashidhar

    Friday, May 11, 2018 9:03 AM

Answers

  • We have used following code to over come this issue.

    HRDB inbound Rule extension

    Switch (FlowRuleName)
       {
        case "cd.person:EndDate->mv.person:employeeEndDate":
                      DateTime time = DateTime.Parse(csentry["EndDate"].Value);
                        mventry["employeeEndDate"].Value = time.ToUniversalTime().ToString("yyyy'-'MM'-'dd'T'HH':'mm':'ss'.000'");
                      break;

    • Marked as answer by Shashidhar J Friday, May 18, 2018 7:47 AM
    Friday, May 18, 2018 7:47 AM