# DateFormat Transform and AD whenChanged attribute

**URL:** <https://developer.sailpoint.com/discuss/t/dateformat-transform-and-ad-whenchanged-attribute/28354>\
**Category:** SHF Discussion and Questions\
**Tags:** transforms, sailpoint-identity-security\
**Created:** [January 31, 2024, 7:56pm UTC](https://developer.sailpoint.com/discuss/t/dateformat-transform-and-ad-whenchanged-attribute/28354 "2024-01-31T19:56:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![moss\_snake\_01](https://avatars.discourse-cdn.com/v4/letter/m/2acd7d/32.png) [@moss\_snake\_01](https://developer.sailpoint.com/discuss/u/moss_snake_01)\
**Post date:** [January 31, 2024, 7:56pm UTC](https://developer.sailpoint.com/discuss/t/dateformat-transform-and-ad-whenchanged-attribute/28354/1 "2024-01-31T19:56:52Z")

</div>

Hello all,

I am attempting to transform the whenChanged attribute from AD into the ISO8601 format.

I mapped the transform through the Identity Profile → Mapping; while previewing, no Identity Value is being displayed, the preview (original?) value is. Example preview value: 20230523142127.0Z

example transform:

```auto
{
    "name": "Date Format Transform for iSeries",
    "type": "dateFormat",
    "attributes": {
        "inputFormat": "LDAP",
        "outputFormat": "ISO8601"
    },
    "internal": false
}

```

I’ve tried different values for both inputFormat and outputFormat :

inputFormat values tried:

LDAP  
yyyyMMddHHmmss.Z  
EPOCH\_TIME\_WIN32

outputFormat values tried:

yyyy-MM-dd HH:mm:ss.S  
ISO8601

Additionally, I’ve tried to add the input accountAttribute for this whenChanged attribute, but in addition to the Identity Value remaining as no value, the Preview Value is no longer displayed.

example:

```auto
{
    "name": "iSeries DateFormat Transform AD whenChanged",
    "type": "dateFormat",
    "attributes": {
        "input": {
            "type": "accountAttribute",
            "attributes": {
                "attributeName": "whenChanged",
                "sourceName": "Active Directory"
            }
        },
        "inputFormat": "yyyyMMddHHmmss.Z",
        "outputFormat": "ISO8601"
    },
    "internal": false
}

```

Any thoughts as to why the transform isn’t working? Thank you!

---

<div class="post-metadata">

**Author:** ![amishra97](https://avatars.discourse-cdn.com/v4/letter/a/50afbb/32.png) [@amishra97](https://developer.sailpoint.com/discuss/u/amishra97)\
**Post date:** [January 31, 2024, 8:27pm UTC](https://developer.sailpoint.com/discuss/t/dateformat-transform-and-ad-whenchanged-attribute/28354/2 "2024-01-31T20:27:05Z")

</div>

Hi @moss_snake_01

Use below transform instead and make sure ‘whenChanged’ attribute is defined in the schema of your AD application,

```auto
{
    "name": "iSeries DateFormat Transform AD whenChanged",
    "type": "dateFormat",
    "attributes": {
        "input": {
            "type": "accountAttribute",
            "attributes": {
                "attributeName": "whenChanged",
                "sourceName": "Active Directory"
            }
        },
        "inputFormat": "yyyyMMddHHmmss",
        "outputFormat": "ISO8601"
    },
    "internal": false
}

```

---

<div class="post-metadata">

**Author:** ![moss\_snake\_01](https://avatars.discourse-cdn.com/v4/letter/m/2acd7d/32.png) [@moss\_snake\_01](https://developer.sailpoint.com/discuss/u/moss_snake_01)\
**Post date:** [January 31, 2024, 10:18pm UTC](https://developer.sailpoint.com/discuss/t/dateformat-transform-and-ad-whenchanged-attribute/28354/3 "2024-01-31T22:18:41Z")

</div>

Thanks, Abhinav. That did the trick! I took the format originally from the doc: [Date Format | SailPoint Developer Community](https://developer.sailpoint.com/idn/docs/transforms/operations/date-format) – which had it:

**LDAP:** This is the date format corresponding to the LDAP date format standard, also expressed as “yyyyMMddHHmmss.Z”.

I took the long format expression as acceptable – but it seems it isn’t coming in as this anyways. Could you help me understand why?

---

<div class="post-metadata">

**Author:** ![amishra97](https://avatars.discourse-cdn.com/v4/letter/a/50afbb/32.png) [@amishra97](https://developer.sailpoint.com/discuss/u/amishra97)\
**Post date:** [January 31, 2024, 11:01pm UTC](https://developer.sailpoint.com/discuss/t/dateformat-transform-and-ad-whenchanged-attribute/28354/4 "2024-01-31T23:01:50Z")

</div>

Hi @moss_snake_01

I am glad it worked out.

This is so because the ‘SimpleDateFormat’ of Java served as the foundation for IdentityNow’s long format expression.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [March 31, 2024, 11:02pm UTC](https://developer.sailpoint.com/discuss/t/dateformat-transform-and-ad-whenchanged-attribute/28354/5 "2024-03-31T23:02:25Z")

</div>

Closed on March 31, 2024, 11:02pm UTC

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