Trouble Linking "Day of year" to Daily Quotes Table

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 :yellow_heart:

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.

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))
4 Likes

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<!!

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.

2 Likes

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<!!

1 Like