Expand my Community achievements bar.

SOLVED

Updating the Timezone for profile by lookup another table

Avatar

Level 2

 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 

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hey,

 

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

 

Regards,

Amit

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

Hey,

 

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

 

Regards,

Amit