Hi Everyone, I am looking for solution to convert the date and time into particular time format, please note time Zone attribute we have been provided just we need to output attribute depending on the time zone given for example Transform reads identity’s Time Zone. Construct local timestamp at 2…

what system is providing the timezone? is it able to also provide the timezone offset? my Workday team was able to give me the timezone offset as a calc field, and i’m able to use that with this lookup transform (this table contains all timezone offsets currently listed in the tz database ): "offset…

Hi @LearningStar Might be helpful. Thanks [image] Timezone-aware termination times? ISC Discussion and Questions Hello! I need to apply a timezone offset to the worker’s termination date so that we can process terminations at a specified time in the worker’s…

You could table format all timezones with a paired attribute of +/- number of hours. Then take output and dateMath it to your existing Endtime. That would do it.

Thanks @sup3rmark for the suggestions but we are not getting the time zone offset we are getting only time zone as Time Zone = “America/New_York” from SuccessFactors based on the time zone we need to convert the end date into particular format which says local timestamp at 23:59 of the selected da…

Manually build yourself a table then. I’m sure CBT can provide you a table format with the left side being the verbose timezone and the right being the numerical offset values

Hi @phil_awlings Do you have any sample transform which I can use as reference as I am not sure how we can use the look up here and perform the conversions ?

Just change the country code to timezone: "CountryZone": { "type": "lookup", "attributes": { "input": { "type": "reference", "attributes": …

I have this built for every country and every major city

i literally posted a sample transform. you just have to change the table to list out the relevant timezones.

Hi @phil_awlings this transform is the complete one how we are calculating the actual dates here ? Is this piece of transform which you have provided to me for reference, could you please provide me the complete one?

Timezone conversion in transform

Identity Security Cloud (ISC) ISC Discussion and Questions

Tursun (Shawn Tursun) March 18, 2026, 2:20pm 2

Hi @LearningStar

Might be helpful. Thanks

Topic		Replies	Views
Timezone-aware termination times? ISC Discussion and Questions transforms , identity-security-cloud , provisioning	6	243	July 13, 2025
How to terminate of AD users in the correct local timezone ISC Discussion and Questions identity-security-cloud , provisioning	13	732	April 8, 2024
Using Identity Attribute in custom Transform ISC Discussion and Questions identity-security-cloud	6	650	March 15, 2024
Dynamic Expression for dateMath ISC Discussion and Questions transforms , apis , identity-security-cloud , identityiq	7	323	July 22, 2024
How to terminate of AD users in the correct timezone ISC Discussion and Questions	5	1316	July 19, 2023

Timezone conversion in transform

Related topics