Is there a way to sort month and year string in google sheet or presto sql?

user_16835873 0
Viewed 34

I have data that looks like this:

campaign_type
marmay2022
janmar2022
mayjul2022

I'm trying to sort it based on the year and the first 3 character according to the month and year.

presto google-sheets-formula google-sheets date
2 Answers

Try:

enter image description here

Formula in C2:

=INDEX(SORT({A2:A4,--("01/"&REPLACE(A2:A4,4,3,"/"))},2,1),0,1)
user_97581940

Give a try on below formula-

=QUERY({A1:A3,ArrayFormula(DATEVALUE("01-"&LEFT(A1:A3,3)&"-"&RIGHT(A1:A3,4)))},"select Col1 order by Col2")

enter image description here

user_55147470
Related