Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

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

Topic Labels: Dates & Timezones
1556 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.