MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management
Reload this Page Search for time range possible? And date question

Notices

Reply
 
Thread Tools Search this Thread
Old 11-10-2013, 02:39 PM   #1
manawydan
Connoisseur
manawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toys
 
Posts: 95
Karma: 5854
Join Date: Aug 2011
Device: none
Search for time range possible? And date question
1.
Is it possible to search for a time range?

To find books added on 9 November 2013 I can use "date:2013-11-09"
But what if I would like to search for books added between lets say 4 November and today?
Or after the 4 November?

Is it possible to vary the date search and if so how?

2.
I noticed that I have about 153 books with no date at all.
Others show 2000.. as date which is not possible since I started with Calibre in 2010.
How is this possible if date is the date of modifying (which includes added)?
I have fixed it now using bulk metadata edit.
manawydan is offline   Reply With Quote
Old 11-10-2013, 03:07 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: 30,949
Karma: 60358908
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 manawydan View Post
1.
Is it possible to search for a time range?

To find books added on 9 November 2013 I can use "date:2013-11-09"
But what if I would like to search for books added between lets say 4 November and today?
Or after the 4 November?

Is it possible to vary the date search and if so how?

2.
I noticed that I have about 153 books with no date at all.
Others show 2000.. as date which is not possible since I started with Calibre in 2010.
How is this possible if date is the date of modifying (which includes added)?
I have fixed it now using bulk metadata edit.
The manual for search http://manual.calibre-ebook.com/gui.html#search-sort

Tote: The Today examples
Code:
date:>=2013-11-09
You may want to do an and search
>= the low_search term and <= the high search term


: The only way I see date being blank is for someone to have cleared it. That is defaulted to the date the Record (line) was added to the Library

Search date:false
theducks is offline   Reply With Quote
Advert
Old 11-15-2013, 04:41 AM   #3
manawydan
Connoisseur
manawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toys
 
Posts: 95
Karma: 5854
Join Date: Aug 2011
Device: none
Thank you.
manawydan is offline   Reply With Quote
Old 11-15-2013, 12:53 PM   #4
jscarbo
Addict
jscarbo ought to be getting tired of karma fortunes by now.jscarbo ought to be getting tired of karma fortunes by now.jscarbo ought to be getting tired of karma fortunes by now.jscarbo ought to be getting tired of karma fortunes by now.jscarbo ought to be getting tired of karma fortunes by now.jscarbo ought to be getting tired of karma fortunes by now.jscarbo ought to be getting tired of karma fortunes by now.jscarbo ought to be getting tired of karma fortunes by now.jscarbo ought to be getting tired of karma fortunes by now.jscarbo ought to be getting tired of karma fortunes by now.jscarbo ought to be getting tired of karma fortunes by now.
 
Posts: 220
Karma: 1075434
Join Date: Apr 2011
Location: Costa Rica
Device: Kindle Voyage, Kindle PW2, Nook HD+, Nexus 7
There are three default columns for date in Calibre - date added, date published and date read. If you've hidden any of the ones you want, you can easily restore them by right clicking at the top of the library list where all of the column names are shown, then hover your mouse pointer over Show Column and select the hidden column(s) you want to restore. Once restored, click on the column name to sort by date.
jscarbo is offline   Reply With Quote
Old 11-15-2013, 01:12 PM   #5
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: 30,949
Karma: 60358908
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 jscarbo View Post
There are three default columns for date in Calibre - date added, date published and date read. If you've hidden any of the ones you want, you can easily restore them by right clicking at the top of the library list where all of the column names are shown, then hover your mouse pointer over Show Column and select the hidden column(s) you want to restore. Once restored, click on the column name to sort by date.
Date read is NOT a standard column

The 3 columns:

Date
Published (pubdate)
Modified (last_modified) [not shown by default]
theducks is offline   Reply With Quote
Advert
Old 11-15-2013, 05:33 PM   #6
manawydan
Connoisseur
manawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toysmanawydan shares his or her toys
 
Posts: 95
Karma: 5854
Join Date: Aug 2011
Device: none
Edit: found my mistake, sorry.
Last edited by manawydan; 11-15-2013 at 05:36 PM.
manawydan is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
"date" reports correct time zone and time; UI reports a time several hours off Synthead Kindle Developer's Corner 17 01-05-2015 05:10 AM
Search for Date added Compere Library Management 6 06-08-2013 04:27 PM
Can you search using Date Modified? Miss A Library Management 2 03-28-2013 11:59 PM
Search on Added Date nynaevelan Calibre 6 11-10-2010 09:15 PM
Search date.. ottovdv Calibre 1 10-26-2010 04:29 AM


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

Contact Us - FAQ - Guidelines - Privacy - Top

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