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
Forget my last query.
I have achieved what I want with the DateDifference Math.
Many Thanks,
Joao Ferreira
system
Closed
August 6, 2024, 1:01pm
6
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.