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!
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")
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")You’re the man, Justin! Thank you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.