Transform DateFormat handling Daylight savings

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

Hello everyone,

I have a transform that will retrieve the lastlogontimestamp from AD and convert it to a user-friendly format. We wish the output to be displayed in NZ time zone. We did it by adding 12hrs to the lastlogontimestamp (as this is by default in GMT+0). Though this is good for now, but when Daylight savings start, we would need to change 12h to 13h. Then change it back again after the Daylight savings and we don’t want that.

Is there a way here where we won’t need to update it twice a year anymore? like set the NZ time zone directly in the transform? or any other workaround?

below is the transform we are using. thanks.

{
    "name": "NZ DateFormat lastLogon",
    "type": "dateFormat",
    "attributes": {
        "input": {
            "attributes": {
                "expression": "+12h",
                "input": {
                    "attributes": {
                        "input": {
                            "attributes": {
                                "values": [
                                    {
                                        "attributes": {
                                            "attributeName": "lastLogonTimestamp",
                                            "sourceName": "Active Directory"
                                        },
                                        "type": "accountAttribute"
                                    },
                                    {
                                        "attributes": {
                                            "value": "0"
                                        },
                                        "type": "static"
                                    }
                                ]
                            },
                            "type": "firstValid"
                        },
                        "inputFormat": "EPOCH_TIME_WIN32",
                        "outputFormat": "ISO8601"
                    },
                    "type": "dateFormat"
                },
                "roundUp": true
            },
            "type": "dateMath"
        },
        "inputFormat": "ISO8601",
        "outputFormat": "dd/MM/yyyy hh:mm a"
    },
    "internal": false
}
2

One way is to use workflow with Schedule trigger (attached image) and add an HTTP action item which will update the transform. Although I guess you need to create 2 workflows to update it to +12 and +13 as month will be different.

Thanks.

undefined

4 Likes
3

This might actually work! will test this out. Thanks a lot!

4

It worked! Thanks a lot!

1 Like
5

Great! thanks for the confirmation.