Updating the Timezone for profile by lookup another table

[samaamcer]

 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 

[Amit_Kumar · Accepted solution]

Hey,

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

Regards,

Amit