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