I have data, imported from csv file. I have set date format on one column, and want to sort by date, but this seems only to sort by raw character values.
27/01/2015
28/01/2015
31/12/2014
This almost certainly happens because of the import settings used when you opened the CSV file in the first place. Open it newly and find the "date" column, then play with the "column type" settings. (Text, dates, etc.) One of the "date" settings should be what you want. Also the check box "detect special numbers" may be applicable—I don't know what other data you are dealing with.
When dates are stored as dates, not as text, they will definitely sort correctly.
(If this answers your question fully, please click the green check mark.)
Hey! I can't get my CSV file to sort by date. The file that this was created from I see is not in order of date. This is very frustrating since it should be so simple. I can't help that someone else (from work) can't enter things in order. However, it should be a simple fix. I am completely new to LO. I upgraded my Mac OS and my old Mac MS Office no longer is supported. Where do I go to "Data" > "Text to Columns"? From the upper pulldown menu or are these icons in the program? THANKS SO MUCH!
Asked: 2015-02-01 06:12:27 +0100
Seen: 19,052 times
Last updated: Feb 01 '15
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
