Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 12-21-2017, 01:27 PM   #1
abqkjh
Zealot
abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.abqkjh ought to be getting tired of karma fortunes by now.
 
abqkjh's Avatar
 
Posts: 147
Karma: 1502780
Join Date: Mar 2013
Device: Moto e5
Is it possible to search by Month?

I would like to be able to pull up all the books I acquired in December (no matter what year). In other words, all the books that have Dec in the "Date." Is that possible, if so how?

Thanks
abqkjh is offline   Reply With Quote
Old 12-21-2017, 03:12 PM   #2
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Quote:
Originally Posted by abqkjh View Post
I would like to be able to pull up all the books I acquired in December (no matter what year). In other words, all the books that have Dec in the "Date." Is that possible, if so how? Thanks
There might be a way to use Regular Expressions in the Search Bar. However, I know for a fact that there is a way to do so using the Multi-Column Search plug-in. See the attached example.


DaltonST
Attached Thumbnails
Click image for larger version

Name:	mcs_dates_sql_search_example.jpg
Views:	149
Size:	425.8 KB
ID:	160843  
DaltonST is offline   Reply With Quote
Advert
Old 12-21-2017, 03:47 PM   #3
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,966
Karma: 30277294
Join Date: Mar 2012
Location: Sydney Australia
Device: none
If its a one-off need, try an search expression like this date:=2015-12 or date:=2016-12 or date:=2017-12 in the search bar.

Or, create a computed custom column (column built from other columns) using the format_date function on the #timestamp (Date) column. See Using functions in templates - single-function mode for more details.

BR
BetterRed is online now   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing Search from Search Bar Not Bringing You back To author menu chantw0968 Calibre 7 11-09-2017 07:51 AM
Regex in search problems (NOT Search&Replace; the search bar) lairdb Calibre 3 03-15-2017 07:10 PM
Regex Search doesn't search all files in Edit Book GregTheGrate Editor 8 11-08-2016 12:47 AM
Get Books search - extremely fuzzy search results? Man Eating Duck Calibre 1 05-06-2013 12:08 AM
Google Book Search to search full-text books online Bob Russell Deals and Resources (No Self-Promotion or Affiliate Links) 1 08-19-2006 12:13 PM


All times are GMT -4. The time now is 05:29 PM.


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