Good morning, I am building a Transportation application for my team to use. When we request a pickup time from our transportation vendor, it is always in central time since we are based in Texas. C...
Thank you! I am still so new at QB, and this all helps, but I still need some help.
I created a table called "Transportation Vendors" with the Airport code, Vendor Name, Phone number, email, time zone, and UTC offset listed. On my request form, I have the Airport code Central time pickup time and the "Local time Pickup time." On my request form, if I chose LAX airport and entered a pickup time of 12 p.m. Central, how would the Local pickup time be calculated to show 10 a.m.? I have the local time pickup time field set as a “Time” Formula.