DATE FORMAT

[JeremiBen]

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 !

[dilipborad · Accepted solution]

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.

• Airtable Formula Field Reference | Airtable Support
• Formula Playground!

[JeremiBen]

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

Thank you !