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.
This topic has been closed for replies.
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.