# How to connect an hour with a date? **URL:** \ **Category:** Ask for Help\ **Created:** [June 14, 2021, 11:22pm UTC](https://community.glideapps.com/t/how-to-connect-an-hour-with-a-date/27994 "2021-06-14T23:22:03Z")\ **Posts on this page:** 1\ **Showing post:** 4
**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 15, 2021, 1:32am UTC](https://community.glideapps.com/t/how-to-connect-an-hour-with-a-date/27994/4 "2021-06-15T01:32:42Z")
I’d have to check how dynamic it is again, but date columns are actually pretty powerful. If you write the text value of ‘Tuesday at 9:00am’ or ‘Next Tuesday at 9:00am’, it will magically figure out the date. The part I’m not completely clear on is if it will dynamically update the date after each date has passed, or if it becomes static. Some reference: > [@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… > [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684/5): > > HOLY COW. [[image] ](https://media.tenor.com/images/3a29726ff95ca4e667c8ec0ae83689ff/tenor.gif) Playing with this for the rest of the day…wonder what would happen if you said “Next Month” on January 30…would it say Feb 28 or Mar. 2? or neither? EDIT: Minutes and hours work too. 3 minutes ago 10 min from now Month Abbreviations work (“Mar” = March 1) Week Abbreviations work (“Next Fri”) “This Morning” = 6am today “This Afternoon” = 3pm today “Tonight” = 10pm tonight “Next Tuesday at 9AM” “Feb 35” = 3/7/2021 Mar 7, 2021 … @robert states it’s dynamic but maybe found a workaround: > [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684/81): > > @Jeff_Hager perhaps a flaw here? > [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684/83): > > I solved it—had to use a math column to convert the text to a date and then pass the math column instead: [Screen Shot 2021-02-10 at 10.48.35 AM] Just some quick testing, when writing text in a date column and then changing it to a text column, it seems to hold it as a static date without time, but somehow retains the time. When writing text in a text column and then changing it to a date column, it seems to hold the text which converts dynamically to the correct date. Again, I’m not completely sure what the behavior will be, but that might be one way to have dynamically changing dates. --- _[View the full topic](https://community.glideapps.com/t/how-to-connect-an-hour-with-a-date/27994)._