# Current time "now" **URL:** \ **Category:** Ask for Help\ **Created:** [March 3, 2023, 5:46pm UTC](https://community.glideapps.com/t/current-time-now/58732 "2023-03-03T17:46:35Z")\ **Posts on this page:** 1\ **Showing post:** 10
**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:** [March 6, 2023, 5:20pm UTC](https://community.glideapps.com/t/current-time-now/58732/10 "2023-03-06T17:20:07Z")
Date type columns always contain a date and a time. That’s just how they work. There is no such thing as a time only type of column. You can format it to only display time, but that is only for display purposes. The underlying date is still there. Date type columns are very interesting in how they work. They are very flexible as far as the format of the date that can be entered. If you were to enter only a time in a date column, it will usually default to the nearest date, which could be yesterday, today, or tomorrow. With that flexibility, you can also pass in words. If you write the word ‘today’ in a date column, it will interpret it as today’s date. If you wrote ‘today at 11:15am’, it would interpret it as today’s date with a time of 11:15. That may be a method you could use, but I’m not sure off the top of my head if the date will dynamically change each day, or if it becomes static. It’s a bit of a hack, but it’s pretty impressive. I dive deeper into that method with this post. > [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684): > > I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum. Can’t find the post in either forum right now. Working on these posts re-triggered this memory. What I had discovered back then is how ridiculously forgiving the calendar layout is. It can take dates in a variety of formats and still determine the correct date to show. But the really cool thing I had discovered is that you can feed it certain types of te… What I would probably do instead, is create some creative date math that would take the now date, basically subtract the time to get it to midnight, and then add in your selected time. It’s a bit to work out the math, but definitely possible. I think I have done it in the past, or something similar, but I’d have to sit down and work it out. I’m pretty confident that it’s doable. This post is probably where I would start to build out the math. > [@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… So to be clear, when you enter a T time, are you doing it through the app, or do you just type it into the data editor? I just want to make sure I understand how the time gets put into that column. --- _[View the full topic](https://community.glideapps.com/t/current-time-now/58732)._