How do I sort by date

asked 2015-02-01 06:12:27 +0200

Milliways
3 ●3 ●3 ●6

updated 2015-02-01 06:14:03 +0200

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

answered 2015-02-01 08:35:28 +0200

Wildcard
172 ●6 ●10 ●14

updated 2015-02-01 08:38:07 +0200

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.)

edit flag offensive delete link

Comments

We may also apply the tool > 'Data' > 'Text to Columns...' to the range of dates wrongly imported as text type data. This will offer the same options as the csv import dialogue.

Lupp ( 2015-02-01 15:16:37 +0200 )edit

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!

dagger ( 2015-08-12 20:17:52 +0200 )edit

add a comment

How do I sort by date

1 Answer

Comments

Question Tools

Stats

Related questions

How do I sort by date edit

1 Answer

Comments

Question Tools

Stats

Related questions

How do I sort by date