
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 31, 2019 10:11 AM
I’m looking to generate a the following fields:
Date (ex: Wednesday, January 1, 2020)
Doors Open Time (ex: 7:00PM)
Show Start Time (ex: 7:30PM)
From a DATE field that represents the show date and show start time (inputted together per Airtable), and a DURATION field that represents how many minutes BEFORE the start time the doors will open.
Anyone know how to write the formulas for this? Much appreciated!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 31, 2019 03:26 PM
Here are the formulas. In all of these, replace “America/Los_Angeles” with the appropriate timezone for you. First, {Event Date}
:
DATETIME_FORMAT(SET_TIMEZONE(Date, "America/Los_Angeles"), "dddd MMMM D, YYYY")
Next {Show Start Time}
:
DATETIME_FORMAT(SET_TIMEZONE(Date, "America/Los_Angeles"), "h:mmA")
Finally {Doors Open Time}
:
DATETIME_FORMAT(SET_TIMEZONE(DATEADD(Date, -1 * {Preshow Time}, "seconds"), "America/Los_Angeles"), "h:mmA")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 01, 2020 02:05 PM
You’re the man, Justin! Thank you.
