Date & Time component without a year

[absolutenathan]

I want to add a birthday system to my app, and the app will detect if the date is the same as today and it will show a happy birthday message. However, the date & time picker won’t let us remove the year, which means that every year the date would need to be updated.

Basically, the date picker needs to be like mm/dd instead of mm/dd/yyyy. Is there any way I can do that?

Thanks!

[ThinhDinh]

You can just keep the date picker setup, and add a math column with the formula:

MONTH(B)*10^2+DAY(B)-MONTH(N)*10^2-DAY(N)

with B being the birthday, N being the “Now” value.

If it results in 0, then show the message, else don’t show anything.

[absolutenathan]

This worked! Thank you!