Skip to main content
Solved

Date Format sending incorrectly to Slack messages despite DATE FORMAT formula

  • July 15, 2021
  • 3 replies
  • 79 views

Forum|alt.badge.img

Despite having created a formula field to format my date, it is still sending this format to slack in automation message: 2021-07-31T10:00:00.000Z (which you can see in the screenshot is still the only selectable property in the automation wizard. The date format in my formula field displays correctly like Thursday, November 19, 2020 3:00 PM. What am I missing? My formula is configured as DATETIME_FORMAT(Start, ‘LLLL’)


Best answer by ScottWorld

That’s weird. It should be showing you the exact same format. It works for me. Maybe try re-testing the trigger by clicking on the “Test Again” button for the Trigger. If not, you may need to email support@airtable.com.

3 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Answer
  • July 16, 2021

That’s weird. It should be showing you the exact same format. It works for me. Maybe try re-testing the trigger by clicking on the “Test Again” button for the Trigger. If not, you may need to email support@airtable.com.


Forum|alt.badge.img

WOW, re-testing the trigger by clicking on the “Test Again” button for the Trigger - FIXED the issue. Go figure! Thank you!


Databaser
Forum|alt.badge.img+25
  • Brainy
  • July 16, 2021

WOW, re-testing the trigger by clicking on the “Test Again” button for the Trigger - FIXED the issue. Go figure! Thank you!


:grinning_face_with_sweat: We’ve all been there