Updating the Timezone for profile by lookup another table

samaamcer

30-12-2019

 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 

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)