# \#Calendar : Convert a date birth in a recurrent date of birth

**URL:** <https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701>\
**Category:** Ask for Help\
**Created:** [May 6, 2022, 4:03pm UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701 "2022-05-06T16:03:55Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fleau75](https://avatars.discourse-cdn.com/v4/letter/f/73ab20/32.png) [@Fleau75](https://community.glideapps.com/u/Fleau75)\
**Post date:** [May 6, 2022, 4:03pm UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/1 "2022-05-06T16:03:55Z")

</div>

Hello,  
I’m new to Glide and I need your help.  
I would like to activate reminders for birthdays by having initially entered their date of birth.  
How to convert the date of birth entered (ex: 06/05/95) into a recurring and annual birthday date (ex: 06/05/22, 06/05/23, 06/05/24…) so that the date can automatically be inserted into the calendar?  
Thank you  
Florence

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [May 6, 2022, 5:21pm UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/2 "2022-05-06T17:21:21Z")

</div>

Hi @Fleau75,

Welcome to the community 🥳

Not good with Dates 🙃 but I think this should work!

All columns :

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/1/0190ffccf87eec30222b120e69208dc6439013e7.png)

Birthday column ( Date and Time Basic column ) that user adds their birthday :

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/44cf30614fbf8806017473d151e81b8c06f9542f.png)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/37a9e2ab9f430bc45c45675be1c2fd0d87e413ef.png)

Day column ( Math column ) that gets the day of the birthday column :

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/8/5839d0efbe2558a89545a76ce7cd01ce00859892.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/73067f5b82110228197ae777d3cefba64acf009d.png)

Month column ( Math column ) that gets the month of the birthday column :

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b51ccd7de5a07286057b0043f5e501c4d363a03e.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/f/4fe4247603abcd242e3287bc2e083a160f9cc686.png)

Now Year column ( Math column ) that gets the year of today’s date :

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/c/4c42a49302541d584ebd0e71e456dde8b386d277.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/5/2588f76aff90054c3703ff8c89058eda1043afb1.png)

Date column ( Template column ) to connect Day,Month,Now Year column to make the date :

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/108987646b92c65b4571a496cd9ab0c84ebc63b2.png)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6fde0de8de93285c0623b9d62c8fa7140e54b853.png)

Display inside the Calendar Layout :

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f00a180bb0353ec8f513aaaf56b2f6a56d229698.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8e2b01086bf1f18656c28eeee70a8965ff79a10e.png)

For test I added 365 days to the Now column and I get the 2023 year :

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/9322264003f371bd9944995bee721593f463c70a.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/a/0a91e36458b0d0bd446014a4e63f7e2438b7b4d3.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2f6639ecd1c127d171afff4a62b043fc0395df7f.png)

Just thought to tag Jeff ( @Jeff_Hager :- Master of Dates ) to know if he has a different solution and to confirm If I’m correct 🙂 Not only Jeff, there are some more makers that so much better with Dates but this post might get like a spam if I tagged them all.

Thank you

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 7, 2022, 12:34am UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/3 "2022-05-07T00:34:38Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f55b994e0c9279d1c4902357b490aae009146012.png)

Here, you can just point it to the “Now” value instead of having to create a “Now” column.

Otherwise, if the template column works in the Calendar view then I would assume that is the correct answer.

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [May 7, 2022, 2:12am UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/4 "2022-05-07T02:12:15Z")

</div>

> [@ThinhDinh](#):
>
> Here, you can just point it to the “Now” value instead of having to create a “Now” column.

Thanks Thinh! I think I overthink-ed that part 😅 I have updated my post!

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 7, 2022, 2:24am UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/5 "2022-05-07T02:24:32Z")

</div>

Haven’t tried this for all dates/years—maybe this works in a single math column?

 ![CleanShot 2022-05-06 at 22.25.22@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7c31759b6570b8385f5f9ea5a22b32a302f2cb11.png)

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [May 7, 2022, 7:48am UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/6 "2022-05-07T07:48:34Z")

</div>

Awesome Robert! Thanks for sharing!

---

<div class="post-metadata">

**Author:** ![Fleau75](https://avatars.discourse-cdn.com/v4/letter/f/73ab20/32.png) [@Fleau75](https://community.glideapps.com/u/Fleau75)\
**Post date:** [May 7, 2022, 1:06pm UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/7 "2022-05-07T13:06:06Z")

</div>

Extra Robert, it works!  
Thank you very much, I’m so impressed with this community, it’s great to have this support.  
Many many thanks !

---

<div class="post-metadata">

**Author:** ![Fleau75](https://avatars.discourse-cdn.com/v4/letter/f/73ab20/32.png) [@Fleau75](https://community.glideapps.com/u/Fleau75)\
**Post date:** [May 7, 2022, 1:08pm UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/8 "2022-05-07T13:08:45Z")

</div>

Thank you very much Dilon for all these explanations.  
For the moment, I used Robert’s method and it worked! For me who is starting and who absolutely does not know how to code at the base, this community is a great help so thank you again for all these shares.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 7, 2022, 10:03pm UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/9 "2022-05-07T22:03:22Z")

</div>

Glad it worked!

---

<div class="post-metadata">

**Author:** ![Michael\_Weiss](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_weiss/32/35265_2.png) [@Michael\_Weiss](https://community.glideapps.com/u/Michael_Weiss)\
**Post date:** [June 7, 2022, 12:32am UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/10 "2022-06-07T00:32:52Z")

</div>

I applied your formula and it works fine except for a date in my current short list… no idea why.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/e/fe83b16cff1f1ff3ec265b827e83fc826315f302.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/56702630d7ea51879c3447bf19b597ca3b288697.png)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [June 7, 2022, 11:40am UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/11 "2022-06-07T11:40:30Z")

</div>

Does this formula work instead?

```auto
(DOB-(year(DOB)*365.25)+(year(now)*365.25)+.5)

```

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 8, 2022, 12:06am UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/12 "2022-06-08T00:06:06Z")

</div>

Was off by 1 day in some cases for me.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1a887cca27ec0b289b16df540a86cc37e2e81424.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 8, 2022, 12:32am UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/13 "2022-06-08T00:32:29Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/8/d8232eb56b01757071040548968802cb3e21000c.png)

```auto
let dob = new Date(p1);

dob.setFullYear(new Date().getFullYear());

const options = {year: 'numeric', month: 'long', day: 'numeric' };

return dob.toLocaleDateString('en-US',options)

```

Needed JS to help with this, but if you want some extra things like “Days left until the next birthday” then maybe we need to work more.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/4/b4b11cb5958d01143cd11c90bfa2de0f6171483a.png)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [June 8, 2022, 1:12am UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/14 "2022-06-08T01:12:34Z")

</div>

Ya…I thought the +.5 would have fixed it…for some reason my original formula was resulting in some dates being 6 hours earlier. Back to the drawing board.

---

<div class="post-metadata">

**Author:** ![Fleau75](https://avatars.discourse-cdn.com/v4/letter/f/73ab20/32.png) [@Fleau75](https://community.glideapps.com/u/Fleau75)\
**Post date:** [June 9, 2022, 1:45pm UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/15 "2022-06-09T13:45:44Z")

</div>

Hello,  
I also had the same problem on some dates and ended up using @Dilon_Perera method explained above by isolating the birth day, birth month, and recomposing the birthday date with the year in course with a Template column. I don’t know if I’m clear 😉

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 10, 2022, 12:12am UTC](https://community.glideapps.com/t/calendar-convert-a-date-birth-in-a-recurrent-date-of-birth/41701/16 "2022-06-10T00:12:41Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/5163e88e2225562a0f84a59135e686f6716ae3ff.png)

There’s an odd case with Feb 29 though (when you try to combine a Feb 29 date in a year that doesn’t have it). JS handles that automatically, so if you want to use the result to calculate it will work.