# 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:** 13\ **Page:** 1
**Author:** ![rloo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rloo/32/54195_2.png) [@rloo](https://community.glideapps.com/u/rloo)\ **Post date:** [March 3, 2023, 5:46pm UTC](https://community.glideapps.com/t/current-time-now/58732/1 "2023-03-03T17:46:35Z")
I had my app working to where it was calculating the time difference between “Ontime” and the current time “now”. For some reason the app stopped working properly all of a sudden and I cannot figure out what would have changed. Picture shows how delta time was calculating the difference. Is it my “Now” (current time) variable? TIA! ![Capture1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/45aadd113eba488f82a04f3e6ed7bd11a9bad791.png) ---
**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 3, 2023, 5:51pm UTC](https://community.glideapps.com/t/current-time-now/58732/2 "2023-03-03T17:51:58Z")
What do you get as a result for your Delta Time? What’s not working? ---
**Author:** ![rloo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rloo/32/54195_2.png) [@rloo](https://community.glideapps.com/u/rloo)\ **Post date:** [March 3, 2023, 6:14pm UTC](https://community.glideapps.com/t/current-time-now/58732/3 "2023-03-03T18:14:27Z")
My delta time for some reason is not calculating correctly. At the time of the screen shot below, the current time was 11:11 am so my delta time should have been 4 minutes? This was not a problem the last time I used the app so it seems like something changed. Thank you! ![Capture2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/9030d1647db7aa5694012d3ddc6c50a98a0f0c94.png) ---
**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 3, 2023, 6:47pm UTC](https://community.glideapps.com/t/current-time-now/58732/4 "2023-03-03T18:47:37Z")
Just quickly testing, it seems to be working for me, but can you explain more about your Ontime column and how that is calculated? Does it maybe have the wrong date somewhere? ---
**Author:** ![rloo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rloo/32/54195_2.png) [@rloo](https://community.glideapps.com/u/rloo)\ **Post date:** [March 3, 2023, 7:24pm UTC](https://community.glideapps.com/t/current-time-now/58732/5 "2023-03-03T19:24:54Z")
the Ontime is and has been calculating correctly so the delta seems to be the culprit all of a sudden. The green times are set times from a table. ![Capture3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b6472db7f137a5e0e95abf3d1f0a8f78e3513abd.png) ---
**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 3, 2023, 11:15pm UTC](https://community.glideapps.com/t/current-time-now/58732/6 "2023-03-03T23:15:00Z")
To the best of my knowledge, I attempted to create the same scenario as yours. These screenshots were taken at approximately 5:05pm. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2b68375002f39ed758832069b3ec79c6a554e41b.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0f940e9bcdf4193d033454d195045b6edfc3b97c.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec4b7b8242d77a66f94922fbcc9fca354a756212.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/2/a227852c4124b825de31a11020661e11027cc23a.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/9/0950874582b6d578cc3c74ef2ac02678b7d6cd35.png) To get anything remotely close to the results you have, I have to change the T time Date/Time to Feb 26th, which is just short of a week ago. I would start there and see what the underlying date is for your T Time column. Since you have a few columns only showing Time instead of Date and Time, I suspect that the underlying date is wrong. Showing only Time doesn’t make it immediately apparent. Double click on the date cells that show only time to see what the true underlying value is. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/ded1302e67c78510436f2ba2fe2d5941a85fe59d.png) ---
**Author:** ![rloo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rloo/32/54195_2.png) [@rloo](https://community.glideapps.com/u/rloo)\ **Post date:** [March 4, 2023, 1:12am UTC](https://community.glideapps.com/t/current-time-now/58732/7 "2023-03-04T01:12:40Z")
Thank you so much. Yes, my T time does show February 27. Why is that? Thanks! ---
**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 4, 2023, 1:17am UTC](https://community.glideapps.com/t/current-time-now/58732/8 "2023-03-04T01:17:23Z")
All depends on how you fill that date, but at least you know the source of the problem now. ---
**Author:** ![rloo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rloo/32/54195_2.png) [@rloo](https://community.glideapps.com/u/rloo)\ **Post date:** [March 6, 2023, 3:12pm UTC](https://community.glideapps.com/t/current-time-now/58732/9 "2023-03-06T15:12:32Z")
the date reflects the day I re-entered the list of times. Is there a way to ignore the date as I’m only interested in the time? ---
**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. ---
**Author:** ![rloo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rloo/32/54195_2.png) [@rloo](https://community.glideapps.com/u/rloo)\ **Post date:** [March 7, 2023, 6:00am UTC](https://community.glideapps.com/t/current-time-now/58732/11 "2023-03-07T06:00:11Z")
very interesting! The T times I just typed into the table. Like I had mentioned, it was working correctly for a couple of weeks and it went south only after I reentered some additional times (on Feb 27). So I’m not sure how or why the date became significant after I re-typed all the times (I couldn’t figure out how to add additional rows so I just retyped all the times). ---
**Author:** ![rloo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rloo/32/54195_2.png) [@rloo](https://community.glideapps.com/u/rloo)\ **Post date:** [March 13, 2023, 3:19pm UTC](https://community.glideapps.com/t/current-time-now/58732/12 "2023-03-13T15:19:55Z")
“Today” is static so that doesn’t work. Trunc(Now) doesn’t seem to work for me. It always returns the current date and time and not midnight. I was trying to do something like Trunc(Now) + 6 hours. Does this work for you? Thanks! ---
**Author:** ![rloo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rloo/32/54195_2.png) [@rloo](https://community.glideapps.com/u/rloo)\ **Post date:** [March 13, 2023, 4:29pm UTC](https://community.glideapps.com/t/current-time-now/58732/13 "2023-03-13T16:29:41Z")
never mind! Did not dive deeper into your previous attachment! Trunc(now) brings me to current date and time as set by seed date and time so I think it will work! Thanks for your help again!