Need to populate locations time zone in locations table

[Esha5]

Hi Team,

In my  location table having location name, city and time zones fields etc..

But all locations showing empty 'Time Zone' , How to set locations time zone.

please help me on this task.

Thanks in Advances.

[Ankur Bawiskar]

@Esha 

Thank you for marking my response as helpful.

If that helped please mark it correct and close the thread.

Regards
Ankur

[Esha5]

Hi Ankur,

my customer is not ready to provide time zone values.

could you please provide any other way to get time zone values in the location table.

Thanks.

[Ankur Bawiskar]

so how would you know which timezone to populate for each location unless you know for each city what timezone it is?

consider there are 100 locations and it has 100 different cities then you cannot store timezone for each city by checking on google and then using some script

Inform the customer to share the timezone for that list of cities or else you would require to manually use if else when you run fix script based on city

Regards
Ankur

[Esha5]

Hi Ankur,

if possible please share fix script to run based on city/country.

Thanks in advance.

[Ankur Bawiskar]

I would suggest you to start so that it would be learning to you as well

Regards
Ankur