I'm importing data from a sheet that uses the Mon/D/YY date format (Apr/13/19).

When I try to sort the entries chronologically with the following request, they're instead sorted alphabetically (A is the column with dates). SELECT A, B, C, D, E ORDER BY A ASC

The command TEXT(date, 'YYYY-MM-DD') allows me to get a date format I can easily sort, but it'd be way easier if I could do it in the first query.

Thank you!

  • pls share a copy of your sheet – user0 Apr 13 '19 at 13:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.