problems with custom date column

Crueltyfre · 12-31-2014, 01:47 PM

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

PeterT · 12-31-2014, 02:24 PM

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).

Crueltyfre · 12-31-2014, 02:35 PM

yep, you're right, thanks so much. Can't believe I didn't see that! Thanks again.

PeterT · 12-31-2014, 02:47 PM

No problem. I know it's easy to assume that mm and MM would be the same.

BetterRed · 12-31-2014, 05:20 PM

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

12-31-2014, 01:47 PM	#1
Crueltyfre Junior Member 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....

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

12-31-2014, 02:35 PM	#3
Crueltyfre Junior Member 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.

12-31-2014, 02:47 PM	#4
PeterT Grand Sorcerer Posts: 12,174 Karma: 73448616 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.

12-31-2014, 05:20 PM	#5
BetterRed null operator (he/him) Posts: 20,586 Karma: 26954694 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