# Text to Date column not working

**URL:** <https://community.glideapps.com/t/text-to-date-column-not-working/79715>\
**Category:** Report a Bug\
**Created:** [February 1, 2025, 2:56pm UTC](https://community.glideapps.com/t/text-to-date-column-not-working/79715 "2025-02-01T14:56:50Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)\
**Post date:** [February 1, 2025, 2:56pm UTC](https://community.glideapps.com/t/text-to-date-column-not-working/79715/1 "2025-02-01T14:56:50Z")

</div>

_First time reporting a bug? [Refer to our Start Here post.](https://community.glideapps.com/t/start-here-reporting-platform-bugs-issues/40)_

* * *

**Team ID:**  
([https://go.glideapps.com/o/8PRvnqgeRctXcuMLh9Lm](https://go.glideapps.com/o/8PRvnqgeRctXcuMLh9Lm))

**App ID:**  
([https://go.glideapps.com/app/gU4ECtcwo53j46yl3sfW/layout](https://go.glideapps.com/app/gU4ECtcwo53j46yl3sfW/layout))

**Description**  
Text to Date is not working. Here an screen shoot:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/f/1f0739390986b68d4729a526591642ac2d670a55.png)

Some of the rows (Gener, Febrer, Març) ara working fine but others change time from the original template (Abril, Maig, Juny…).

**How to replicate**

Please check the issue since I’m stoped at this point and I can go further.

Thanks-

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [February 1, 2025, 4:45pm UTC](https://community.glideapps.com/t/text-to-date-column-not-working/79715/2 "2025-02-01T16:45:00Z")

</div>

It has probably something to do with the respect timezone option. Try to uncheck it.

---

<div class="post-metadata">

**Author:** ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)\
**Post date:** [February 1, 2025, 5:05pm UTC](https://community.glideapps.com/t/text-to-date-column-not-working/79715/3 "2025-02-01T17:05:52Z")

</div>

Thanks Maxime,

I’ve already tried that but still the error remains:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/8321336f5d172c5fec7017e03500a3055e349ec2.png)  
And it’s so wierd that it happens in some rows but no inthe others…

Thanks for your advice anyway;)!

Any other tips will be apreciatte.

Albert

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [February 1, 2025, 5:15pm UTC](https://community.glideapps.com/t/text-to-date-column-not-working/79715/4 "2025-02-01T17:15:52Z")

</div>

Is it possible that it happens when there is no time in the template?

---

<div class="post-metadata">

**Author:** ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)\
**Post date:** [February 1, 2025, 5:27pm UTC](https://community.glideapps.com/t/text-to-date-column-not-working/79715/5 "2025-02-01T17:27:02Z")

</div>

I’m afraid it’s not the case… See Abril, Maig where is a time informed but the text to date doesn’t work…

---

<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:** [February 1, 2025, 7:42pm UTC](https://community.glideapps.com/t/text-to-date-column-not-working/79715/6 "2025-02-01T19:42:41Z")

</div>

I’m guessing daylight savings is factoring in for any dates between March 9 and November 2. Might need to do something with specifying UTC or a specific timezone or offset.

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [February 1, 2025, 8:52pm UTC](https://community.glideapps.com/t/text-to-date-column-not-working/79715/7 "2025-02-01T20:52:24Z")

</div>

I wonder if template column could potentially change something in the date config that create an issue when using that column somewhere else.

---

<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:** [July 31, 2025, 8:52pm UTC](https://community.glideapps.com/t/text-to-date-column-not-working/79715/8 "2025-07-31T20:52:28Z")

</div>

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