[Solved] Sorting by date in a spreadsheet

[cwr1946]

Downloaded a checking account transaction file (.csv), saved as .ods file. Now trying to sort the entries by date. The data in the date column is by m(m)/d(d)/yyyy. How can I sort these entries by calendar date? I've defined the format of that column as date 12/31/1999, but when I sort I get 1/xx/yyyy (ALL January entries by day of month for ALL years) then 10/xx/yyyy (All October entries by day of month for ALL years). How can I get OO to recognize the date and sort correctly?

[Villeroy]

You must not ignore the import options.
Always check the "special numbers" option.
Choose any English locale except USA when importing dd/mm/yyyy dates.
Choose English (USA) when importing mm/dd/yyyy dates.
Once you imported the correct values, you can format them any way you want. Formatting never ever changes a single value. However, correct values can be calculated, filtered and sorted correctly.

[Zizi64]

How can I get OO to recognize the date and sort correctly?

The real dates are numeric values. Calc can sort the numeric values.
Use the import filter properly for converting the date-like strings (of the .csv file) to numeric type.