Sort text column as date

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 :frowning: )

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.


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

It worked!

Thanks so much

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!

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