Workday to Active Directory - Integrating Workday dates to AD system times
We would like to be able to integrate Workday date fields with Active Directory timestamp fields.
For example, we would like to map "End Employment Date" to "accountExpires" however AD stores dates/times in SYSTEMTIME. If an employee is created in Workday and their End Employment Date was 30/05/2019, this time would need to flow to Active Directory as "132036552000000000". From what I have read, this number represents 100-nanoseconds intervals since 01/01/1601.
If we were able to integrate these fields, we could ensure our contractors' AD access would be revoked at the correct time. Unfortunately the custom expressions that are available in Azure Active Directory won't allow the format conversion to occur.
We'd really appreciate this functionality! Our auditors would love it too :o)
Thank you for suggesting and upvoting this idea. Happy to share that you can now set the accountExpires flag in AD based on date information from Workday. This is achieved by using a new function called NumFromDate that you can use in the expression mapping.
For more details refer to this link:
John Adamson commented
Try using this: NumFromDate([StatusTerminationLastDayOfWork]) should work ok for the above
Peter Mburu commented
PAHO is very interested in this functionality.