Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 12-22-2011, 09:00 PM   #1
James76
Junior Member
James76 began at the beginning.
 
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?
James76 is offline   Reply With Quote
Old 12-22-2011, 09:04 PM   #2
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: 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:
Originally Posted by James76 View Post
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?
What Calibre Version?
What OS (and version)
theducks is offline   Reply With Quote
Advert
Old 12-22-2011, 09:20 PM   #3
James76
Junior Member
James76 began at the beginning.
 
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.
James76 is offline   Reply With Quote
Old 12-22-2011, 09:24 PM   #4
James76
Junior Member
James76 began at the beginning.
 
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
James76 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 10:44 AM.


MobileRead.com is a privately owned, operated and funded community.