Help

Re: DATE FORMAT

Solved
Jump to Solution
496 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
8 - Airtable Astronomer
8 - Airtable Astronomer

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
8 - Airtable Astronomer
8 - Airtable Astronomer

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 !