How do I choose the desired time zone? (not set it via formula)


#1

I am trying to create an application for tracking my travel. I would like to have the following fields:
Flight1DepartureDate
Flight1DepartureTime
Flight1DepartureTimeZone
Flight1Airline
Flight1Number
Flight1DepartureCity
Flight1DepartureAirport
Flight1ArrivalCity
Flight1ArrivalAirport
Flight1ArrivalDate
Flight1ArrivalTime
Flight1ArrivalTimezone

allowing me to enter data such as:
Delta 123 leaves Atlanta (ATL) 01/01/2018 9:30am ET arrives in San Francisco (SFO) 01/01/2018 12:30pm PT

Any help would be appreciated. (and I’d be happy to share the app if I can get it working!)


#2

A ugly hack may be to use a Zapier to create a Zap and update the record according to the desired timezone you want…


#3

The SET_TIMEZONE() function just takes a string to set the Timezone, so you could use the appropriate Timezone string in the Arrival Timezone and Departure Timezone fields:

And then interpolate the string into the formula in the main Date/Time Field:
DATETIME_FORMAT(
SET_TIMEZONE(
{Arrival Date},
‘{Arrivale Timezone}’
),
… etc