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.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.