Manually tweak date (& time?) added?

Snorkledorf · 04-09-2014, 08:26 AM

Say I have books 1 and 3 of a trilogy, and add them to calibre. A year later I finally locate book 2 and add it too.

Now the series is split in two different places in my library (which I like keeping sorted with newest books at the top).

Is there a way I can change the date-added info in a sufficiently fine-grained manner that calibre's sorting would insert book 2 in-between books 1 and 3? Say, 1 second after the time that I added book 1, but before book 3.

(I'm actually trying to insert a dozen scattered issues into a 100-issue magazine run, so it's a little bit more complex than the above...)

kovidgoyal · 04-09-2014, 09:37 AM

You can edit day month and year, that should be quite sufficient, unless you insist on preserving the day, in which case you will need to edit the metadata.db file directly using a sqlite browser tool.

04-09-2014, 08:26 AM	#1
Snorkledorf Blue. Not sad...just blue Posts: 218 Karma: 1267018 Join Date: Oct 2009 Location: Japan Device: Ridibooks Paper Pro	Manually tweak date (& time?) added? Say I have books 1 and 3 of a trilogy, and add them to calibre. A year later I finally locate book 2 and add it too. Now the series is split in two different places in my library (which I like keeping sorted with newest books at the top). Is there a way I can change the date-added info in a sufficiently fine-grained manner that calibre's sorting would insert book 2 in-between books 1 and 3? Say, 1 second after the time that I added book 1, but before book 3. (I'm actually trying to insert a dozen scattered issues into a 100-issue magazine run, so it's a little bit more complex than the above...)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date added	Sablerose	Marvin	1	02-03-2014 11:34 AM
K4NT - How to set time manually? And other questions	Beemspam01	Amazon Kindle	0	04-20-2013 03:14 AM
Date Added column? Can I set date when book added to library?	fitzhugh	Calibre	4	06-03-2012 05:42 PM
Date Added vs. Date Modified	aglaia761	Calibre	5	11-28-2010 05:34 AM
Time & Date Updates Not Saving	elburks	Astak EZReader	4	01-02-2010 03:13 PM

04-09-2014, 09:37 AM	#2
kovidgoyal creator of calibre Posts: 45,255 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	You can edit day month and year, that should be quite sufficient, unless you insist on preserving the day, in which case you will need to edit the metadata.db file directly using a sqlite browser tool.

Advert