1. Is it possible to calculate the timezone based on the country/state field value of a record? If so how?
  2. Is it possible to display the time field with the timezone it relates to? If so how?
  • 1. Yes. 2. Yes. – user735 Jan 16 '15 at 17:54
  • 2
    Actually, no for #1. Several US States have more than one time zone. – Matt Johnson-Pint Jan 16 '15 at 20:21
  • 1
    Russia has many timezones – cropredy Jan 16 '15 at 20:31
  • Have you tried something, looked in the documentation perhaps ? – Samuel De Rycke Jan 20 '15 at 12:45
  • where do I start? I know how to format the time but I don't know how to calculate based on the timezone of the record. – Bartley Jan 20 '15 at 13:38
  1. Yes

You can implement a double web service to hit any Geolocation API then any Timezone API. Here is Google's Geolocation API which will get you a latitude and longitude of City/State combo. Here is Google's Timezone API which will get you the timezone offset.

  1. Yes

Once you store the above offset, you should be able to use the offset to modify any date on a record to account for the offset.

  • Unless @Bartley has changed his tune, I'll bet he is looking for a clicks, not code solution :-) – cropredy Jan 20 '15 at 18:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.