function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Bidun TummalaBidun Tummala 

Field that saves the time based on time Zone for reporting.

Is there a way that i can create a 3 Formula fields that stores which save timings in EST CST and PST.

 

It would be even more helpful if i have a formula fields that give me 0 or 1 value based on the timings. 

 

The fields will have value one if

 

Between 8am to 5pm EST

 

Between 8am to 5pm CST

 

Between 8am to 5pm PST

 

I need this field  for reporting.

 

Thank you very much..

 

Regards,

Bidun

IspitaIspita

Hi,

I think you can create :-

  • custom fields to store this information
  • and use javascript based code to derive the time in different time zones based on current time and zone.
  • check following links for help:-

http://www.techrepublic.com/article/convert-the-local-time-to-another-time-zone-with-this-javascript/6016329

 

Hope this helps...