Syncing to Employee Hire Date in Azure AD

Hello. I am trying to sync from our HR source the hire date of any employee. The account I am testing is a cloud only resource and is not in our on-prem AD. The hire date format in the HR file is 11/5/2024. How can i get the sync to write to the value Employee hire date on the properties page in Azure ?

HI @joeykennedy,

Please refer this document of Attribute Sync to sync attributes from HR source to target source (Entra).

Synchronizing Attributes - SailPoint Identity Services

Thanks.

@joeykennedy

I agree with Nikhlesh that you should be able to use attribute sync to set this value. You should also be able to add this to your create profile.

Two things to keep in mind:

  1. You will need to add employeehiredate to your schema.
  2. You will likely need to format this date as “YYYY-MM-DDThh:mm:ssZ” for it to be set in Azure correctly.

i was able to get it to work but there appears to be a 5 hour time discrepancy. So if the source date is 10/5/2024 it comes into azure as 10/4/2024 at 7:00 PM. Any idea how to fix that ?

Hi @joeykennedy,

The easiest way I can think of is by using a Date Math transform. Simply create a new identity attribute and apply the Date Math transform to it.
Here’s an example - Date Math | SailPoint Developer Community
By changing the expression to +5h/h, you should be able to use this identity attribute to sync the hire date and time.

Also, depending on your requirement, make sure to set the roundup to true or false, and configure the output format as suggested by @agutschow.

Hope this helps!

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.