Return
-
Title
Date/Time Field sync with Quick Connect not working -
Description
Sync the SAP Entry & Leaving Date with Quick Connect to Quest One Identity Manager does not work
error message: String was not recognized as valid DateTime format.
-
Cause
The issue has occurred as the SAP date returned is dd.mm.yyyy format but Q1IM requires yyyy-mm-dd format.
-
Resolution
The issue has occurred as the SAP date returned is dd.mm.yyyy format but Q1IM requires yyyy-mm-dd format.
To resolve this you have to add the script rule below for the Entry & Leaving Date provisioning rule:
$value=$srcObj[“srcAttrName”]
$numbers=$value.Split(@('.'),0)
$numbers[2] +"-"+ $numbers[1] + "-" + $numbers[0]