Google Spreadsheet Post #2428
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Apr-17-2018
question by: Sabrina3241
https://productforums.google.com/forum/#!topic/docs/P-F5jAm0waA;context-place=forum/docs
Sort by a column that has mm/dd/yyyy - chronological, not by first digit
My sheet keeps sorting the column by month, instead of mm/dd/yyyy. For example:
I want it in chronological order by date, not by the first number. I cannot share the spreadsheet, but here is my formula:
=query(importrange("link", "Sheet1!A:AS"), "select Col4, Col18, Col19, Col20, Col21, Col22, Col25, Col26, Col27, Col39 where Col18 contains '1' or Col20 contains '1' or Col21 contains '1' or Col22 contains '1' order by Col39 asc format Col39 'mm/dd/yyyy'",0)
I want it in chronological order by date, not by the first number. I cannot share the spreadsheet, but here is my formula:
=query(importrange("link", "Sheet1!A:AS"), "select Col4, Col18, Col19, Col20, Col21, Col22, Col25, Col26, Col27, Col39 where Col18 contains '1' or Col20 contains '1' or Col21 contains '1' or Col22 contains '1' order by Col39 asc format Col39 'mm/dd/yyyy'",0)
No comments:
Post a Comment