Skip to main content

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 !

 

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.

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.


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

Thank you !

Reply


Terms & Conditions