Thread: New sorting issues?
View Single Post
Old 05-13-2012, 01:44 PM   #8
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,134
Karma: 60406498
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by olaf View Post
I just started recording the date purchased in a new column in my calibre library. I set it up in the format of mm/dd/yyyy and entered several dates. But I then tried to sort by date and it seemed that it was sorting by the "day" numeric only. I changed the format to yyyy-mm-dd and tried sorting again, but still messed up - it's not sorted by date correctly. What am I doing wrong? It's defined as a date, and I assumed it's stored all one way, no matter what the output format is. How do I ensure that stuff entered is correctly sorted by date in ascending or descending order?
Strange
I have several date (MM/dd/yyy, dd MMM yyyy hh) columns. They all sort perfectly.

Calibre on XP Sp3 is my most used OS

Check the tweak # Control how dates are displayed
theducks is offline   Reply With Quote