Help

Using date and duration to generate standalone date, standalone time, and standalone time - duration?

Topic Labels: Dates & Timezones
976 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Heather_Dragule
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

2 Replies 2

Screen Shot 2019-12-31 at 3.23.18 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")

You’re the man, Justin! Thank you.