# Date/Date-Time entry don't recognize Date/Date-Time column **URL:** \ **Category:** Report a Bug\ **Created:** [September 22, 2020, 10:32pm UTC](https://community.glideapps.com/t/date-date-time-entry-dont-recognize-date-date-time-column/16216 "2020-09-22T22:32:22Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [September 22, 2020, 10:32pm UTC](https://community.glideapps.com/t/date-date-time-entry-dont-recognize-date-date-time-column/16216/1 "2020-09-22T22:32:22Z")
Take a look on **End Date Agendar** and the date I’m tryna schedule in second screen 👇 they’re exactly the same. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7697f1bed0bbd33216f7f0f0de8bc49314097312.jpeg) In Data Editor I’m tryna do a relation to see, but it can’t recognize it as the same date-time… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/2c1865c54281dddbd89c8d65d975ce6410d4178e.png) I’ve already setup the column in google sheet, tried to setup in data editor and keep it like this. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/92b3b15002bc1d73c5294f807aa2f8b069d2bfbf.png) In my **Space Schedule** when I click on the date, appears like this 👇 could be something about how’s date is shown up in glide? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/ad55421908071f563e8b1d2fc61e2d1cd2293efd.png) ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [September 23, 2020, 7:47am UTC](https://community.glideapps.com/t/date-date-time-entry-dont-recognize-date-date-time-column/16216/2 "2020-09-23T07:47:35Z")
@Mark could be something about how’s date is shown up in glide? ---
**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:** [September 23, 2020, 11:50am UTC](https://community.glideapps.com/t/date-date-time-entry-dont-recognize-date-date-time-column/16216/3 "2020-09-23T11:50:57Z")
Are both dates on each side of the relation using the underlying ISO format timestamp, or is one of the dates typed in manually into the sheet and the other one entered through the app? I’m thinking you could create a template of the date to lock in the formatting on one or both dates and then use the template for the relation. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [September 27, 2020, 10:48pm UTC](https://community.glideapps.com/t/date-date-time-entry-dont-recognize-date-date-time-column/16216/4 "2020-09-27T22:48:07Z")
> [@Jeff\_Hager](#): > > Are both dates on each side of the relation using the underlying ISO format timestamp, or is one of the dates typed in manually into the sheet and the other one entered through the app? No, Jeff… first is a Date entry, and the second is when i submit the form > [@Jeff\_Hager](#): > > I’m thinking you could create a template of the date to lock in the formatting on one or both dates and then use the template for the relation. I also tried that, and no success ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [September 27, 2020, 10:48pm UTC](https://community.glideapps.com/t/date-date-time-entry-dont-recognize-date-date-time-column/16216/5 "2020-09-27T22:48:28Z")
@mark did i miss something?? ---
**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\ **Post date:** [September 27, 2020, 11:19pm UTC](https://community.glideapps.com/t/date-date-time-entry-dont-recognize-date-date-time-column/16216/6 "2020-09-27T23:19:15Z")
@Lucas_Pires is End Date Agendar in Glide only? ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [September 28, 2020, 12:07am UTC](https://community.glideapps.com/t/date-date-time-entry-dont-recognize-date-date-time-column/16216/7 "2020-09-28T00:07:44Z")
Yes, it’s user-specific ---
**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\ **Post date:** [September 28, 2020, 6:12am UTC](https://community.glideapps.com/t/date-date-time-entry-dont-recognize-date-date-time-column/16216/8 "2020-09-28T06:12:33Z")
@Lucas_Pires this might work. there’s a comma in Glide’s short date/time formatting that causes a hiccup. ![agendar](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/28d031c9685f2264737776611e6227f26579895d.png) Set the Display on the EndDateAgendar user specific column to Date only / short. Then duplicate it with math column (m\_EndDateAgendar) and set the Display to Time Only / Without secs. Do a template column to join both (tpl\_EndDateAgendar). In sheets, use the below formula on the End Date: ``` ={"End Date V2";ARRAYFORMULA((IF(LEN(T2:T) = 0, "", text(T2:T,"M/DD/YYYY H:MM AM/PM"))))} ``` End Date V2 should now match with tpl\_EndDateAgendar and give you a relation 🤞🏼 ![sheets](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/79031ea60e792bfce67b7da9aaa7c38acf65dac5.png) ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [September 28, 2020, 6:15am UTC](https://community.glideapps.com/t/date-date-time-entry-dont-recognize-date-date-time-column/16216/9 "2020-09-28T06:15:04Z")
Thanks @Rasha But I’d like a way to do it without using formulas 🙁