Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Re: DATE FORMAT

Solved
Jump to Solution
1299 0
cancel
Showing results for 
Search instead for 
Did you mean: 
JeremiBen
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, 

I have a cell with a date picking like "20240204 12:00" and I would like to format the date to "Feb 4th".

I don't find how to reformat in this particular format. 

 

Thank you for your help !

 

1 Solution

Accepted Solutions
dilipborad
9 - Sun
9 - Sun

Hello @JeremiBen 

Create a new Formula field.

Then add this formula to the formula editor.

 

DATETIME_FORMAT({date}, "MMM DD")

 

{date} is a date field in your table.

There are lot's of other ways you can use the formulas but just need to follow the syntax and give right input.

Check these official documentation from Airtable.

See Solution in Thread

2 Replies 2
dilipborad
9 - Sun
9 - Sun

Hello @JeremiBen 

Create a new Formula field.

Then add this formula to the formula editor.

 

DATETIME_FORMAT({date}, "MMM DD")

 

{date} is a date field in your table.

There are lot's of other ways you can use the formulas but just need to follow the syntax and give right input.

Check these official documentation from Airtable.

JeremiBen
5 - Automation Enthusiast
5 - Automation Enthusiast

Perfect, thank you ! I thougt I read it somewhere but couldn't find it. 

Thank you !