# Show users birthday if it's today

**URL:** <https://community.glideapps.com/t/show-users-birthday-if-its-today/75282>\
**Category:** Ask for Help\
**Created:** [July 30, 2024, 12:37pm UTC](https://community.glideapps.com/t/show-users-birthday-if-its-today/75282 "2024-07-30T12:37:35Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joao\_Santos\_Ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joao_santos_ferreira/32/40525_2.png) [@Joao\_Santos\_Ferreira](https://community.glideapps.com/u/Joao_Santos_Ferreira)\
**Post date:** [July 30, 2024, 12:37pm UTC](https://community.glideapps.com/t/show-users-birthday-if-its-today/75282/1 "2024-07-30T12:37:35Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 30, 2024, 12:43pm UTC](https://community.glideapps.com/t/show-users-birthday-if-its-today/75282/2 "2024-07-30T12:43:59Z")

</div>

- In your Users table, create two math columns using the following formula:

```auto
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.

---

<div class="post-metadata">

**Author:** ![Joao\_Santos\_Ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joao_santos_ferreira/32/40525_2.png) [@Joao\_Santos\_Ferreira](https://community.glideapps.com/u/Joao_Santos_Ferreira)\
**Post date:** [July 30, 2024, 12:49pm UTC](https://community.glideapps.com/t/show-users-birthday-if-its-today/75282/3 "2024-07-30T12:49:57Z")

</div>

> [@Darren\_Murphy](#):
>
> ```auto
> Month(Date)*10^2
> + Day(Date)
> 
> ```

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

Thanks,

---

<div class="post-metadata">

**Author:** ![Joao\_Santos\_Ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joao_santos_ferreira/32/40525_2.png) [@Joao\_Santos\_Ferreira](https://community.glideapps.com/u/Joao_Santos_Ferreira)\
**Post date:** [July 30, 2024, 12:55pm UTC](https://community.glideapps.com/t/show-users-birthday-if-its-today/75282/4 "2024-07-30T12:55:09Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Joao\_Santos\_Ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joao_santos_ferreira/32/40525_2.png) [@Joao\_Santos\_Ferreira](https://community.glideapps.com/u/Joao_Santos_Ferreira)\
**Post date:** [July 30, 2024, 1:01pm UTC](https://community.glideapps.com/t/show-users-birthday-if-its-today/75282/5 "2024-07-30T13:01:35Z")

</div>

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

Many Thanks,  
Joao Ferreira

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [August 6, 2024, 1:01pm UTC](https://community.glideapps.com/t/show-users-birthday-if-its-today/75282/6 "2024-08-06T13:01:43Z")

</div>

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