Date compare Transform disabled accounts with future End dates

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

I made a change in our production environment on Monday to how the LCS is calculated for our non-employees & contractors based on the end date. Below is the transform that I used and for some reason it set the LCS of some users with future dates to inactive, for instance a user had an end date of 12/16/2025 and it changed their LCS to inactive

“name”: “Calculate_NonEmployee_LifecycleState”,

"type": "dateCompare",

"attributes": {

    "firstDate": {

        "attributes": {

            "input": {

                "type": "reference",

                "attributes": {

                    "id": "Normalize End Date"

                }

            },

            "inputFormat": "mm/dd/yyyy",

            "outputFormat": "ISO8601"

        },

        "type": "dateFormat"

    },

    "secondDate": "now",

    "operator": "gt",

    "positiveCondition": "Active",

    "negativeCondition": "inactive"

},

"internal": false
2

This is due to using lowercase mm (minutes) for the month rather than MM.

Make sure to test transforms in a lower environment before making changes in Production.

Example here:

2 Likes
3

Thank you for pointing that out. I did test the same transform in our Sandbox environment, and it was working. I am going to make the change in our Sandbox and test again.