Identity Profile Date Transform

[mike.lim]

Hello,

I’m attempting to synchronize the “Employee hire date” attribute from an authoritative source to Azure AD.

However, there’s a discrepancy in the date format between the authoritative source and Azure AD. To resolve this issue, I’m trying to transform the date format before the synchronization.

I suppose the similar format is LDAP, as mentioned in the documentation below provided by SailPoint; however, it’s missing “f” before “Z” which is a requirement in Azure AD (as shown above).

Date Format | SailPoint Developer Community

Does anyone have experience in transforming dates to synchronize them with Azure AD?

[sidharth_tarlapally (TARLAPALLY SIDHARTH)]

Hi Mike ,
Good day !
If you clearly read the overview of Date format operator , it is understandable that we can compose any date format which are part of Java SimpleDateFormat class.

Please refer to Java Simple Date Format Class and check if your format can be acheived with this .
The following is a similar transform , which is not the part of recognised date formats :

{
“attributes”: {
“inputFormat”: “yyyy-MM-dd’T’HH:mm”,
“outputFormat”: “dd-MMM-yyyy”,
“input”: “2024-09-05T11:46”
},
“type”: “dateFormat”
}

This transform returns 05-SEP-2024. I hope this helps . Don’t forget to refer to java docs which I mentioned . Refer to this section in docs , this might help your issue.

Thank you!