Formula for formatting Date from YYYY-MM-DD to MM-DD only

How can i solve that problem with the seatable formulas? Need this for Birthday Reminders via Zapier.

Welcome to the SeaTable Forum!

The date column only accepts fully qualified dates including year. In other words, you will succeed in putting a MM-DD date format in a date column.

But why don’t you store the birthday in a date column and use a formula to extra month and day. Could be something like this ‘month({birthday})&“-”&day({birthday})’. The {birthday} is a reference to the column in which you store the birthday.