# How do I use the column that converts text to date?

**URL:** <https://community.glideapps.com/t/how-do-i-use-the-column-that-converts-text-to-date/76847>\
**Category:** Ask for Help\
**Created:** [October 4, 2024, 10:36pm UTC](https://community.glideapps.com/t/how-do-i-use-the-column-that-converts-text-to-date/76847 "2024-10-04T22:36:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Higor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/higor/32/79708_2.png) [@Higor](https://community.glideapps.com/u/Higor)\
**Post date:** [October 4, 2024, 10:36pm UTC](https://community.glideapps.com/t/how-do-i-use-the-column-that-converts-text-to-date/76847/1 "2024-10-04T22:36:16Z")

</div>

How should I fill in these other fields so that the column works? The format, time zone and locale can be any…

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/7/47d50e469f75250da5a4e6281732dce6dec25d0b.png)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [October 5, 2024, 3:40am UTC](https://community.glideapps.com/t/how-do-i-use-the-column-that-converts-text-to-date/76847/2 "2024-10-05T03:40:47Z")

</div>

Format needs to use luxon formatting (click the link in window to see the characters you need). You’ll also want to set timezone offset. I usually use utc±\_\_.