# Date & time column value from a relation

**URL:** <https://community.glideapps.com/t/date-time-column-value-from-a-relation/10818>\
**Category:** Report a Bug\
**Created:** [June 13, 2020, 8:40pm UTC](https://community.glideapps.com/t/date-time-column-value-from-a-relation/10818 "2020-06-13T20:40:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mthakershi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mthakershi/32/1715_2.png) [@mthakershi](https://community.glideapps.com/u/mthakershi)\
**Post date:** [June 13, 2020, 8:40pm UTC](https://community.glideapps.com/t/date-time-column-value-from-a-relation/10818/1 "2020-06-13T20:40:06Z")

</div>

![Screen Shot 2020-06-14 at 2.06.49 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1e5ac177caa78e36181d9355f66149cb3bffd1c2.png)  
Even though I’ve set date format in the editor to human readable format, this shows techy value. When I got into the screen, it does show a proper date value.

---

<div class="post-metadata">

**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 13, 2020, 8:47pm UTC](https://community.glideapps.com/t/date-time-column-value-from-a-relation/10818/2 "2020-06-13T20:47:54Z")

</div>

Might be a similar or the same bug.

> [@In-app filter with dates shows dates in ugly format](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/3):
>
> I could have sworn somebody else reported this recently, but I can’t find a post. This is the closest thing I could find, so maybe this is what I was thinking of.

---

<div class="post-metadata">

**Author:** ![mthakershi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mthakershi/32/1715_2.png) [@mthakershi](https://community.glideapps.com/u/mthakershi)\
**Post date:** [June 21, 2020, 7:12pm UTC](https://community.glideapps.com/t/date-time-column-value-from-a-relation/10818/3 "2020-06-21T19:12:26Z")

</div>

FYI. Workaround. I added a template column that just copies value of the date time column. Then use this template column in the details portion for showing value. It works with proper format. Thanks.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 8, 2024, 5:39pm UTC](https://community.glideapps.com/t/date-time-column-value-from-a-relation/10818/4 "2024-02-08T17:39:21Z")

</div>