12-22-2011, 09:00 PM | #1 |
Junior Member
Posts: 4
Karma: 10
Join Date: Dec 2011
Device: None
|
Date column giving me incorrect result
I've added a new column to show me the date when I add new books to calibre. I've set the column type to "Date" and the "format for dates" to yyyy-mm-dd. It should give me "2011-12-22" for December 22 2011, but it's giving me "2011-06-22". And, any date I pick from the popup calendar shows the month as 06.
If I place the mouse over the data in the column, the popup shows the correct date with the time, but the data in the column is incorrect. Any Suggestions? |
12-22-2011, 09:04 PM | #2 | |
Well trained by Cats
Posts: 29,689
Karma: 54369090
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
What OS (and version) |
|
Advert | |
|
12-22-2011, 09:20 PM | #3 |
Junior Member
Posts: 4
Karma: 10
Join Date: Dec 2011
Device: None
|
Win 7 64bit, Calibre 0.8.31
I noticed something different. The number for the month seems to be the minutes instead of month. I've manually clicked on a few rows and set the date in the calendar. It entered 9 a few times, and then 10, and then 14, no matter what month I picked. As I hovered the mouse over the data, I've noticed the data for month is actually the minute it was entered, not the month that I selected. |
12-22-2011, 09:24 PM | #4 |
Junior Member
Posts: 4
Karma: 10
Join Date: Dec 2011
Device: None
|
I think I figured it out. I was using a little m for months and I need to use an upper case M. The date and year work lower case, but I guess the month needs to be upper case.
When I enter yyyy-MM-dd I get the correct results. Thanks |
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Modified date timestamp incorrect? | lgladen | Calibre | 12 | 08-19-2014 09:49 AM |
Date column is gone | aliza | Library Management | 3 | 04-25-2011 07:17 PM |
Calibre 0.6.14 incorrect publish date | elmoglick | Calibre | 16 | 02-09-2011 02:24 PM |
Incorrect Date on kindle 3 | yogibare143 | Amazon Kindle | 5 | 12-05-2010 05:43 PM |
Incorrect Date on Input | kazbates | Calibre | 2 | 03-19-2009 12:08 AM |