Skip to main content

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

  • January 18, 2018
  • 2 replies
  • 43 views
A

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!)

This topic has been closed for replies.

2 replies

A
Forum|alt.badge.img+3
  • Andrew_Johnson1
  • Participating Frequently
  • January 19, 2018

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

J
Forum|alt.badge.img+18

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

Terms & ConditionsAccessibility statement