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

User Talk Base design
1

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

2

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
3

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