Updating the Timezone for profile by lookup another table

We want to update the profile timezone for the by lookup another table for example

we have a table with the customer ID and GMT offset as 1234,120 120 means GMT + 2

we don't get timezone from CRM so all timezone is default

Is there a way where we can write a query like if GMT = 120 then update with "GMT + 2 "

or any looup we can create

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Amit_Kumar

Hey,

write a workflow which will update the timezone based on your table on an hourly basis.

Regards,

Amit

Amit_KumarAccepted solution

Level 10

Hey,

write a workflow which will update the timezone based on your table on an hourly basis.

Regards,

Amit

Sign up