# Problem with Date/Time column

**URL:** https://community.glideapps.com/t/problem-with-date-time-column/42486
**Category:** Ask for Help
**Created:** [May 28, 2022, 11:46pm UTC](https://community.glideapps.com/t/problem-with-date-time-column/42486 "2022-05-28T23:46:04Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Tancrede](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tancrede/32/9675_2.png) [@Tancrede](https://community.glideapps.com/u/Tancrede)
#### Post date: [May 28, 2022, 11:46pm UTC](https://community.glideapps.com/t/problem-with-date-time-column/42486/1 "2022-05-28T23:46:04Z")

</div>

Hi all,

I need your help !  
I have a Glide table where data is written from a Glide form. One of the column in a Date/Time column.  
Today, I just noticed that most of the data has been “transformed”, I don’t know why.

Here is a screenshot :

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/66ffca9c29db1286f9d99b305ce3047672c4134b.jpeg)

Because of this, Glide don’t recognize the transformed cells as Date/Time, and i can’t use those data in the app (i mean, for “if\>then\>else” column…).

Does anyone know what happened ? And if i could do something to correct this ?  
I’m a bit anxious, as it’s an important part of my app 😰

Thanks a lot !

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 29, 2022, 12:36am UTC](https://community.glideapps.com/t/problem-with-date-time-column/42486/2 "2022-05-29T00:36:05Z")

</div>

> [@Tancrede](#):
>
> Today, I just noticed that most of the data has been “transformed”, I don’t know why.

It should always have been that format underneath, regardless of how you format it in a normal date/time column. Can you show us how you configure those columns?

---

<div class="post-metadata">

### Author: ![Tancrede](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tancrede/32/9675_2.png) [@Tancrede](https://community.glideapps.com/u/Tancrede)
#### Post date: [May 30, 2022, 6:10am UTC](https://community.glideapps.com/t/problem-with-date-time-column/42486/3 "2022-05-30T06:10:05Z")

</div>

Hi !  
Thanks a lot for your answer, and sorry to have taken so much time to respond.  
All things went back to normal, i don’t know why. The whole column is now back to the short date only format, and the rest of the app is now able to use these informations.  
I really don’t know what happened in the first place and what corrected it, but it now works !

Thanks again, have a nice day !

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 30, 2022, 9:46am UTC](https://community.glideapps.com/t/problem-with-date-time-column/42486/4 "2022-05-30T09:46:36Z")

</div>

No probs, glad it works now. Have a nice week!

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [May 31, 2022, 9:47am UTC](https://community.glideapps.com/t/problem-with-date-time-column/42486/5 "2022-05-31T09:47:17Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
