Best answer

Date / Time Formatter

  • 19 March 2021
  • 3 replies
  • 81 views

Userlevel 1
Badge +1

Has anyone had a real good play with this, I have used it on a few zaps and it has been great however I am looking for something quite specific and I cannot see how to do it:.

Scenario:
Time / date output from AirTable is in Zulu Time (example: 2011-08-12T20:17:46.384Z).

I would like to run through the formatter and come out with say, “Friday the 11th at 10am”.

 

Has anyone done something similar?

icon

Best answer by Buttonjer 19 March 2021, 06:02

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 1
Badge +1

Nevermind, I found it easier to do through AirTable directly by adding two formula fields

 

hey, something new to learn! Never thought of showing date in this format - going to give a shot on my blog. Thank you!

What formula did you use in these two columns?