Hello, I have a drop down field 'Time Zone' which contains options such as EDT, EST, PDT, PST. I have a few automatic functions I need to develop using these options.
1. I want to display only PDT, EDT, MDT, AKDT, HDT options when daylight saving time occurs and when it is not daylight savings, I need to display PST, EST, MST, AKST and HST options in the drop down.
2. There are two time of the day fields. 'Intended Arrival Time' and ' Time of Action', which are populated manually. When 'Intended Arrival Time' field is of a given value, I need to change the value of 'Time of Action' field to Arizona time according to the time zone and daylight savings.
What formula should I use or any special fields to achieve this objective?
------------------------------
Raj Helaiya
------------------------------
Question
Display timezone values according to date created or current date.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.