Hi,
We have an employee list board that includes a list of birthdays. I have set the date column format to only include the month and day but the only way that I can get that formatting to work is if the year is set to the current year. So any birthdays that were entered last year or before that, they are showing up with the year showing at the end.
Is this a known issue or does anyone know how to fix that?
Hi @kcastaneda , Tom from monday here. You’re right, on the date column, you can only use full dates with a specific year, and you can’t insert just a pinpoint. I’m curious to hear what your goal is here 
If you just want the date to be displayed on the board, you can use a Formula column, and use the FORMAT_DATE() function. If you want to use it for an automation that sends employees “happy birthday” messages or a reminder notification to their manager, you can use a date automation, for example: “When the date arrives, notify someone, and then push data by 12 months”.
Hi Tom,
Thanks for your suggestion. We are only using that column to note people’s birthdays for internal celebrations and social posts so we don’t need the year displayed at all. I guess we could also just use a text column to track those but I assumed since that format is specifically listed in the date column settings, it would be an option. Good to know now though. We’ll change the column type to something else.
