How to convert a text column into a real date that Glide recognizes as date column?

[Mateo]

Hey everyone,

I have a Query Result column that returns dates in ISO format (2026-04-24T13:00:00). The problem is that Glide reads it as text, not as a date — so I can’t use date filters like “is before”, “is after”, or “is within” on it.

Things I’ve tried that didn’t work:

• Format Date column → always outputs text, useless for filtering

• Math column pointing to the Query Result → still shows as text in If->Then->Else, no date operators available

The only workaround I found was a JavaScript column that compares the date manually using new Date(p1), which works but gives me a text output, not a real date column.

My question: Is there a native way in Glide to convert a text column into a proper date that Glide recognizes as a date type — so I can use it in filters, conditions, and If->Then->Else with date operators?

Any help appreciated!

[Jeff_Hager]

Have you tried a Text to Date column?

[Mateo]

I have but i always get to the same issue:

I have a date in Fecha del servicio but when i use the Text to Date column it never gives the same time because of the time zone.

The problem is that i cant specify an specific timezone because we operate in 6 different cities with 4 different timezones, so if i specify a timezone it will show a wrong time in the other 5 cities

Im guessing a solution would be create and if else column to identify the city and depending of the city, apply an specific timezone, but is that the only turn around??

Or im not using the Text to Date column correctly?

[Jeff_Hager]

What timezone does the date in Fecha del servicio represent? Is it GMT or a different timezone?