MobileRead Forums - View Single Post

olaf · 05-13-2012, 01:09 PM

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?

ETA: I m using Calibre version 8.51

05-13-2012, 01:09 PM	#7
olaf Enthusiast Posts: 43 Karma: 50 Join Date: May 2009 Device: Kindle3	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? ETA: I m using Calibre version 8.51 Last edited by olaf; 05-13-2012 at 01:42 PM.