# Today and 14 days ahead

**URL:** <https://community.glideapps.com/t/today-and-14-days-ahead/57669>\
**Category:** Ask for Help\
**Created:** [February 8, 2023, 6:40pm UTC](https://community.glideapps.com/t/today-and-14-days-ahead/57669 "2023-02-08T18:40:00Z")\
**Posts on this page:** 1\
**Showing post:** 25

<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:** [February 10, 2023, 12:41am UTC](https://community.glideapps.com/t/today-and-14-days-ahead/57669/25 "2023-02-10T00:41:43Z")

</div>

> [@nathanaelb](#):
>
> Intuitively, since Date is the integer and Time the float (at least this is my understanding), then I would have expected TRUNC(DateTime) to be Date (at midnight).

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)`. Probably should have thought of that instead. That makes a lot more sense.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/d/8d99e21fd4315668359529bc8ca08c4c6d8329cf.png)

I wish Glide had functions in the math column to convert text to date, similar to Google’s DATE and DATEVALUE functions. Then we wouldn’t need some of these extra columns to make these functions work.

(Sorry guys, I’m living in the past. Feb 9th really is today for me. 😉 )

---

_[View the full topic](https://community.glideapps.com/t/today-and-14-days-ahead/57669)._