# Sort text column as date

**URL:** <https://community.glideapps.com/t/sort-text-column-as-date/63349>\
**Category:** Ask for Help\
**Created:** [June 30, 2023, 12:56pm UTC](https://community.glideapps.com/t/sort-text-column-as-date/63349 "2023-06-30T12:56:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ryan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ryan/32/15941_2.png) [@Ryan](https://community.glideapps.com/u/Ryan)\
**Post date:** [June 30, 2023, 12:56pm UTC](https://community.glideapps.com/t/sort-text-column-as-date/63349/1 "2023-06-30T12:56:32Z")

</div>

Hi guys,  
a simple (?) one today.

I have a MM-YYYY column in Excel, and all I want Glide to do is sort it as date values (01/2021 followed by 02/2021 and not 01/2021 ☹ )

I don’t mind adding dummy days (saying mark all rows as the first of the given month) if that would help.

Thanks a lot, Ryan.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/982321d55600b043efb376e740848bf501ea0b2f.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 30, 2023, 1:18pm UTC](https://community.glideapps.com/t/sort-text-column-as-date/63349/2 "2023-06-30T13:18:27Z")

</div>

If you reverse the format and make it YYYY-MM, then it will sort naturally.

---

<div class="post-metadata">

**Author:** ![Ryan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ryan/32/15941_2.png) [@Ryan](https://community.glideapps.com/u/Ryan)\
**Post date:** [June 30, 2023, 2:38pm UTC](https://community.glideapps.com/t/sort-text-column-as-date/63349/3 "2023-06-30T14:38:55Z")

</div>

It worked!

Thanks so much

---

<div class="post-metadata">

**Author:** ![Guillaume\_RABALLAND](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/guillaume_raballand/32/35847_2.png) [@Guillaume\_RABALLAND](https://community.glideapps.com/u/Guillaume_RABALLAND)\
**Post date:** [June 30, 2023, 3:55pm UTC](https://community.glideapps.com/t/sort-text-column-as-date/63349/4 "2023-06-30T15:55:58Z")

</div>

yes I was about to answer the same: I also often use this “hack” to naturally sort documents like invoices in Google Drive with the date YYYY-MM-DD in the title, simplest and most efficient turnaround!

---

<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 1, 2023, 3:56pm UTC](https://community.glideapps.com/t/sort-text-column-as-date/63349/5 "2023-07-01T15:56:10Z")

</div>

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