DateMath Tranform results in blank output value with no error display

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

I have created a Tranform which does date math operation of performing 1 day minus the end date(fireddate) from HR Source. and display the resulted date. In my case the result is blank. it seems their is something wrong in the out put date format I tried all possible ways but still the output attribute value is blank. and their is no error shown.

note: input date format for fired date from SAP HR system is “people_soft”

{
        "id": "79b3b9e4-d299-48f6-ab39-3d827b24ad05",
        "name": "Enddate combo",
        "type": "firstValid",
        "attributes": {
            "input": {
                "attributes": {
                    "type": "accountAttribute",
                    "input": {
                        "attributeName": "fireddate",
                        "sourceName": "SAP HR DB- DEV (SAPUsers)"
                    },
                    "inputFormat": "PEOPLE_SOFT",
                    "outputFormat": "yyyy-MM-dd"
                },
                "inputFormat": "yyyy-MM-dd’T’HH:mm",
                "outputFormat": "PEOPLE_SOFT"
            },
            "type": "dateFormat",
            "attributes": {
                "input": {
                    "expression": "-1d",
                    "roundUp": true
                },
                "type": "dateMath"
            },
            "inputFormat": "yyyy-MM-dd",
            "outputFormat": "yyyy-MM-dd"
        },
        "internal": false
    },
2

What is your inputFormat date format ? PEOPLE_SOFT is not reconized format.

3

I will do like this :

 {
        "id": "79b3b9e4-d299-48f6-ab39-3d827b24ad05",
        "name": "Enddate combo",
        "type": "firstValid",
        "attributes": {
            values :  [
                {
                    "attributes": {
                      "expression": "-1d",
                      "roundUp": true,
                      "input": {
                        "attributes": {
                          "input": {
                            "attributes": {
                              "sourceName": "SAP HR DB- DEV (SAPUsers)"
                              "attributeName": "fireddate"
                            },
                            "type": "accountAttribute"
                          },
                          "inputFormat": "MMM dd yyyy, HH:mm:ss.SSS",
                          "outputFormat": "ISO8601"
                        },
                        "type": "dateFormat"
                      }
                    },
                    "type": "dateMath",
                }, 
                ""
            ]
                
                
        }

    }

Please replace : inputFormat by your source “SAP HR DB- DEV (SAPUsers)” date format and outputFormat with desire output format.

4

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