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-31-2014, 01:47 PM   #1
Crueltyfre
Junior Member
Crueltyfre began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Dec 2014
Device: Kindle Paperwhite
problems with custom date column

I have made a custom column which is to be the date I read a book. I choose "column type" of "date" and "format for dates" is yyyy mm.

[IMG][/IMG]

The column shows up correctly and yyyy is displayed correctly.

The mm aspect is totally messed up and seems to pick random numbers that do not correspond to anything (days or months). I've seen the number 59 there for instance. I can click this column once, and it will display, for example, "2014 38" and then click on another book and it will display "2014 16" ...it is not consistent which screwy number it picks.
If I click on the drop down arrow the calendar month is shown, with the correct day highlighted, but this does not fill in the correct day or month into my column.

[IMG][/IMG]

I can manually go in and highlight the screwy digits that are suppose to represent the months and manually change them to the correct digits and they do change and stay correct. I'm just sick of doing this.

This has been occurring over multiple versions. Since updating to 2.14 it's gotten even more annoying...if I accidentally fill out this column for the wrong book, it will not allow me to delete the entry, so now I have a "date read" for a book I haven't read simply because I clicked the wrong line/book.

What am I doing wrong here? How can I get this column to simply display the correct year and month that I read a book? How can I delete entries in the wrong row?
Thanks

Last edited by Crueltyfre; 12-31-2014 at 01:52 PM. Reason: left something important out....
Crueltyfre is offline   Reply With Quote
Old 12-31-2014, 02:24 PM   #2
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 10,770
Karma: 61292701
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
Take a look at http://manual.calibre-ebook.com/temp...-format-string

Your problem is the mm; mm refers to MINUTES. You want either M or MM.
Quote:
M : the month as number without a leading zero (1 to 12).
MM : the month as number with a leading zero (01 to 12).
PeterT is offline   Reply With Quote
Old 12-31-2014, 02:35 PM   #3
Crueltyfre
Junior Member
Crueltyfre began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Dec 2014
Device: Kindle Paperwhite
yep, you're right, thanks so much. Can't believe I didn't see that! Thanks again.
Crueltyfre is offline   Reply With Quote
Old 12-31-2014, 02:47 PM   #4
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 10,770
Karma: 61292701
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
No problem. I know it's easy to assume that mm and MM would be the same.
PeterT is offline   Reply With Quote
Old 12-31-2014, 05:20 PM   #5
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 15,721
Karma: 18415750
Join Date: Mar 2012
Location: Sydney Australia
Device: none
I remember it this way: a Month is bigger than Minute, ergo a Month must be big MM and a minute a little mm

BR
BetterRed is offline   Reply With Quote
Reply

Tags
calibre, custom columns, date

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom column date MerlinMama Library Management 6 08-01-2014 09:49 PM
Custom Column Date Question tarisea Library Management 4 01-13-2014 05:01 PM
Date custom column built from a Y/N one? glos Library Management 3 08-25-2013 12:48 PM
custom date column from two state column Dopedangel Library Management 7 01-03-2012 08:20 AM
Custom column for date added Gunnerp245 Calibre 2 07-08-2011 04:39 PM


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


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