DATE FORMAT

JeremiBen · ‎Jan 05, 2024

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 · ‎Jan 05, 2024

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.

dilipborad · ‎Jan 05, 2024

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 · ‎Jan 05, 2024

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

Thank you !