View Single Post
Old 04-16-2021, 07:41 AM   #6
BetterRed
null operator (he/him)
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: 21,752
Karma: 30237526
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by meghane_e View Post
Sorry, but there's still some confusion. In this case, I do not care about the date a book was published by an official source (author, publishing company, etc). I only care about choosing/finding the earliest date a book record was created in my Calibre databases in merging books. Currently, the only way I know is to manually select the merge order in order to retain the earliest date.

If #date column IS the correct field to use for book creation date in the database, my problem then is that it doesn't show up in my list of available Bulk Edit Search fields. The only default date fields that appear on the list are #pubdate and #last_modified. Is #date supposed to be listed there?
Thanks
First up, the '#'s are only used on custom columns, standard columns don't need them, i.e. Published/pubdate, Title/title etc.

The column you want is Date/timestamp

Click image for larger version

Name:	Screenshot 2021-04-16 212621.jpg
Views:	214
Size:	105.3 KB
ID:	186642

But IIRC it isn't available in Bulk Edit Search & Replace, and I don't remember why. But nor do I see how it would help you with your Merge issue.

BR
BetterRed is offline   Reply With Quote