Show users birthday if it's today

Hi Guys,

Could you please give some tips on how I can have a tab showing our users birthday.
We have a list of users and in the Aniversary tab we want to have a list of users that his birthday is today.

Is there any option to achieve this?

Thanks,
Joao Ferreira

  • In your Users table, create two math columns using the following formula:
Month(Date)*10^2
+ Day(Date)
  • in one formula, substitute Date with the Users birth date
  • in the other formula, substitute Date with the special Now value (current date/time)
  • If both columns give the same result, it is the users birthday today.
2 Likes

Perfect @Darren_Murphy it works.
You’re the man, always saving me with the best tips.

Thanks,

1 Like

Just one more query if possible.
To show the age is it possible? If not you already made my day :smiley:

Forget my last query.
I have achieved what I want with the DateDifference Math.

Many Thanks,
Joao Ferreira

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