Conditional Formatting Column

[Sally_de_Witt]

Hello
I have converted an Excel spreadsheet into an Airtable base.
In excel, I have columns that are formatted to show [month] & [weeknum] based on a date that is entered.
Is this possible in Airtable?
Kind regards,
Sally

[Kamille_Parks · Accepted solution]

You would need one field for the date, and another field (a formula) to format the date:

DATETIME_FORMAT({Date Field}, "MM ww")

Airtable Support

Supported format specifiers for DATETIME_FORMAT

The DATETIME_FORMAT function will allow you to reformat the data from the date-type field into a string of your specifications. This is written in the format of DATETIME_FORMAT(Datetime, 'format sp...

Or you resign to use a single line text field and format the month/week num yourself.