# Date formatting

**URL:** <https://community.glideapps.com/t/date-formatting/2612>\
**Category:** Ask for Help\
**Created:** [December 4, 2019, 1:11pm UTC](https://community.glideapps.com/t/date-formatting/2612 "2019-12-04T13:11:59Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [December 4, 2019, 2:28pm UTC](https://community.glideapps.com/t/date-formatting/2612/2 "2019-12-04T14:28:07Z")

</div>

I don’t think Glide is saving it as a true date value. It’s appears to just be text. Try this formula. It strips out the T and Z, then converts it to a date value which can be reformatted using TEXT:

`=TEXT(DATEVALUE(MID(A2:A,1,10)) + TIMEVALUE(MID(A2:A,12,8)), "DD/MM/YYYY")`

---

_[View the full topic](https://community.glideapps.com/t/date-formatting/2612)._