Skip to main content

Time Issues in Airtable

  • November 5, 2018
  • 3 replies
  • 24 views
C
Forum|alt.badge.img+4

I am working on generating some automatic emails through Zapier to confirm a time set in Airtable.

I have the date field set up to display time as well and am using a formula field to format a message using the date field values.

For some reason, when I use DATETIME_FORMAT({Scheduled Installation}, ‘HH:MM’), the time returned is showing a different number than what is displayed in my date field.

For instance, I currently have the time in my date field set to 1:30am, but the formula field is returning 1:11.

Any guesses? Also, when I toggle off ‘Use the same time zone…’, the time changes to 6:11.

    3 replies

    W
    Forum|alt.badge.img+5
    • W_Vann_Hall
    • Inspiring
    • November 5, 2018

    The format specifier 'HH:MM' is saying ‘format the date and time as 0 to 24 hours, a colon, and a two-digit representation of the month.’ All November dates will show as ##:11.

    What you want is 'HH:mm' using a 24-hour clock or 'hh:mm' for a 12-hour clock. :winking_face:

      C
      Forum|alt.badge.img+4
      • CAHerrmann
      • Author
      • Known Participant
      • November 5, 2018

      The format specifier 'HH:MM' is saying ‘format the date and time as 0 to 24 hours, a colon, and a two-digit representation of the month.’ All November dates will show as ##:11.

      What you want is 'HH:mm' using a 24-hour clock or 'hh:mm' for a 12-hour clock. :winking_face:


      annnd…deleting this post. lol.

      Not enough coffee this morning, apparently.

      W
      Forum|alt.badge.img+5
      • W_Vann_Hall
      • Inspiring
      • November 5, 2018

      annnd…deleting this post. lol.

      Not enough coffee this morning, apparently.


      If I wasn’t neck-deep in moving boxes, I would have taken the time to track down and link to my earlier bug report where I made a similar complaint. It’s an easy problem to catch — the second time around. :winking_face:

      Terms & ConditionsAccessibility statement