Show users birthday if it's today

Ask for Help
1

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

2
  • 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.
3

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

Thanks,

4

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

5

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

Many Thanks,
Joao Ferreira