# Rolling Calendar Availability

**URL:** <https://community.glideapps.com/t/rolling-calendar-availability/62437>\
**Category:** Ask for Help\
**Created:** [June 4, 2023, 6:07pm UTC](https://community.glideapps.com/t/rolling-calendar-availability/62437 "2023-06-04T18:07:39Z")\
**Posts on this page:** 1\
**Showing post:** 7

<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:** [June 5, 2023, 4:25am UTC](https://community.glideapps.com/t/rolling-calendar-availability/62437/7 "2023-06-05T04:25:08Z")

</div>

I think this was the best solution I had come up with.

> [@Today and 14 days ahead](https://community.glideapps.com/t/today-and-14-days-ahead/57669/25):
>
> Yes, that is definitely true, and Trunc(Now) is essentially the date at midnight, but the result for today is 44966 which can be converted back to a normal date in Google, but there is no function in Glide to convert it back to a date. 44966 is the number of days since Dec 30th 1899. That’s not a number that’s useful for me to subtract a few hours. I guess an easier alternative would be to set the seed date to Dec 30th 1899 at midnight and then change the math column to seed+TRUNC(now). Pro…

---

_[View the full topic](https://community.glideapps.com/t/rolling-calendar-availability/62437)._