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 @PhilRawlings1 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 @PhilRawlings1 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

SailPoint Human Fabric (SHF) SHF 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? SHF Discussion and Questions transforms , identity-security-cloud , provisioning	5	325	May 14, 2025
How to terminate of AD users in the correct local timezone SHF Discussion and Questions identity-security-cloud , provisioning	12	807	February 8, 2024
Using Identity Attribute in custom Transform SHF Discussion and Questions identity-security-cloud	5	708	January 15, 2024
Mastering Timezone & Daylight Savings Management in ISC Transforms Community Blog workflows , transforms , apis , identity-security-cloud	2	63	September 10, 2026
Dynamic Expression for dateMath SHF Discussion and Questions transforms , apis , identity-security-cloud , identityiq	6	381	May 23, 2024

Timezone conversion in transform

Related topics