Birthday reminder

[BOTFORCE]

Hi all,

I try to create a birthday reminder in Appsheets. Therefore I compare the birthdate [Geburtsdatum] with Today(). When I do this I receive a false for an try in my test:

Day and Month are similar. What am I doing wrong?

Thx. Robert

[Suvrutt_Gurjar · Accepted solution]

Robert:

Day and Month are similar. What am I doing wrong?

Your current expression compares even the year along with the date and month and year today (2021) is not matching the year 1973 the [Geburtsdatum] column.

Could you please try the below

NUMBER(TEXT([Geburtsdatum],“DDMM”))=NUMBER(TEXT(TODAY(),“DDMM”))
or even
TEXT([Geburtsdatum],“DDMM”)=TEXT(TODAY(),“DDMM”)

These expressions compare only date and month parts.

help.appsheet.com

TEXT()

Format as text

[BOTFORCE]

Thank you! It works!