Skip to main content

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

  • December 31, 2019
  • 2 replies
  • 25 views
H

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!

    This topic has been closed for replies.

    2 replies

    Justin_Barrett
    Forum|alt.badge.img+21

    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")
    H
    • Heather_Dragule
    • Author
    • New Participant
    • January 1, 2020

    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.

    Terms & ConditionsAccessibility statement