# Display Date/time information in meaningful form

**URL:** <https://community.glideapps.com/t/display-date-time-information-in-meaningful-form/18483>\
**Category:** Ask for Help\
**Created:** [November 16, 2020, 11:06am UTC](https://community.glideapps.com/t/display-date-time-information-in-meaningful-form/18483 "2020-11-16T11:06:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\
**Post date:** [November 16, 2020, 11:06am UTC](https://community.glideapps.com/t/display-date-time-information-in-meaningful-form/18483/1 "2020-11-16T11:06:08Z")

</div>

I have set a text to Date/time column which records the date time of submitting a form. How can I get it to display in a proper such as DD/MM/YYYY hh:mm:ss. Currently, it is showing as 2020-11-15T02:03:14.880Z. Thanks

---

<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:** [November 16, 2020, 11:52am UTC](https://community.glideapps.com/t/display-date-time-information-in-meaningful-form/18483/2 "2020-11-16T11:52:06Z")

</div>

You can go to that column inside the builder and change the format in a datetime column.

If you need to view it in the Sheet as well, here’s the link:

> **[Format numbers in a spreadsheet - Computer - Docs Editors Help](https://support.google.com/docs/answer/56470?co=GENIE.Platform=Desktop&hl=en)**