Rolling Calendar Availability

[Jeff_Hager]

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

Today and 14 days ahead

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…