# Trouble Linking "Day of year" to Daily Quotes Table

**URL:** <https://community.glideapps.com/t/trouble-linking-day-of-year-to-daily-quotes-table/82885>\
**Category:** Ask for Help\
**Created:** [July 2, 2025, 2:29pm UTC](https://community.glideapps.com/t/trouble-linking-day-of-year-to-daily-quotes-table/82885 "2025-07-02T14:29:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![PleaseLaugh](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PleaseLaugh](https://community.glideapps.com/u/PleaseLaugh)\
**Post date:** [July 2, 2025, 2:29pm UTC](https://community.glideapps.com/t/trouble-linking-day-of-year-to-daily-quotes-table/82885/1 "2025-07-02T14:29:02Z")

</div>

Hi, I’m trying to show a different quote each day based on the day of the year

I created a column “Current date” with Glide’s current date/time

Then I created a “day” column showing the first day of year

Then I created a math column “day of year” using this formula:  
(Current date - Date) / 86400000 + 1

It gives me the value 24:00:00

Which is wrong, but to try this I connected it to the Quote’s day number (which is a number column) and typed 24 as the number of the quote, and it doesn’t work

I tried using multiple match, still no luck. Any idea what might be going wrong?

Thank you so much 💛

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 2, 2025, 4:16pm UTC](https://community.glideapps.com/t/trouble-linking-day-of-year-to-daily-quotes-table/82885/2 "2025-07-02T16:16:13Z")

</div>

Try this formula instead. Only feed it the current date (Now) value. You don’t need a current date column or a first day of the year column. It should automatically reset each year.

```auto
Round(Date-
(((Date+CEILING((YEAR(Date)-YEAR(Date))*365.2424)-DAY(Date)+15)-(MONTH(Date)-1)*30)-DAY((Date+CEILING((YEAR(Date)-YEAR(Date))*365.2424)-DAY(Date)+15)-(MONTH(Date)-1)*30)+1))

```

---

<div class="post-metadata">

**Author:** ![PleaseLaugh](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PleaseLaugh](https://community.glideapps.com/u/PleaseLaugh)\
**Post date:** [July 2, 2025, 5:22pm UTC](https://community.glideapps.com/t/trouble-linking-day-of-year-to-daily-quotes-table/82885/3 "2025-07-02T17:22:27Z")

</div>

Do I do it in a math column? I plugged it in, it’s asking me for a replacement, I just made a column and typed now in the column and plugged it in, I’m not sure if this now will update everyday, does if you type now in a column row, and this now will update?

and thank you so much \>u\<!!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 2, 2025, 5:27pm UTC](https://community.glideapps.com/t/trouble-linking-day-of-year-to-daily-quotes-table/82885/4 "2025-07-02T17:27:03Z")

</div>

Yes, put it in a math column. You don’t need to create a separate Now column. Now is a built in value to use as a replacement.

 ![1000005455](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6df3bd1ab83b1bd71e661a1fec6345f0cc44e412.jpeg)

---

<div class="post-metadata">

**Author:** ![PleaseLaugh](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PleaseLaugh](https://community.glideapps.com/u/PleaseLaugh)\
**Post date:** [July 2, 2025, 5:35pm UTC](https://community.glideapps.com/t/trouble-linking-day-of-year-to-daily-quotes-table/82885/5 "2025-07-02T17:35:08Z")

</div>

OMG it works! thank you so much! Yay! it took me the whole day to try to figure it out, now I’ll make a new post on another problem that’s taking me the whole day, hopefully it wouldn’t appear I’m making too much posts.

Thanks again!!! \>o\<!!

---

<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:** [July 9, 2025, 5:36pm UTC](https://community.glideapps.com/t/trouble-linking-day-of-year-to-daily-quotes-table/82885/6 "2025-07-09T17:36:08Z")

</div>

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