Sort text column as date

[Ryan]

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.

[Darren_Murphy]

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

[Ryan]

It worked!

Thanks so much

[Guillaume_RABALLAND]

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!