In the Settings of the Synchronizer, you will find a field called Custom date and time format. This is an optional setting in the Synchronizer and is used when the date and time fields cannot be easily understood by the tool.
The format that the field takes, is a text representation of a DateTime object. You are able to find the definition for the format specification on this page: Custom date and time format strings - .NET | Microsoft Learn
Examples
Using the DateTime documentation, below are a few examples:
| Date Time Format | Expected Output |
| yyyy-MM-dd | 2024-02-04 |
| yyyy-M-d | 2024-6-7 |
| yyyy-MM-ddTHH:mm:ssZ | 2024-05-06T13:00:00Z |
| MM/dd/yyyy hh:m:s tt | 06/04/2024 05:4:3 AM |
Entra Id DateTime Fields
DateTime fields that exist in Entra Id (Creation date and Hire Date) use a specific format that will need to be inputted into the Custom date and time format field. The format that Entra Id uses is yyyy-MM-ddTHH:mm:ssZ.
Comments
Article is closed for comments.