Page 1 of 1

filtering searches or smart groups by date

Posted: Wed Feb 01, 2017 4:21 pm
by othoms
Currently it seems not possible to create smart groups (or Find in Library) that are restricted to particular date ranges. Is this correct? For instance, I would like to create a smart group based on keywords that returns only references published after 2010. Is there a work-around?

Best,
Timo

Re: filtering searches or smart groups by date

Posted: Wed Feb 01, 2017 4:58 pm
by Jon
I suspect you can do something like this with an SQL search. Here's a quick example (I'm sure there are better ways):

thedate REGEX '201[0-9]'

will find references where the date field holds a 4 digit (or larger) number beginning with "201"

Jon
Sonny Software

Re: filtering searches or smart groups by date

Posted: Wed Feb 01, 2017 5:01 pm
by othoms
Can this be done with smart groups?

Re: filtering searches or smart groups by date

Posted: Wed Feb 01, 2017 5:13 pm
by Jon
That IS for a smart group (SQL).

Jon
Sonny Software

Re: filtering searches or smart groups by date

Posted: Wed Feb 01, 2017 5:29 pm
by othoms
Great. I realize now that SQL/Regex search from the dropdown menu (Refs) is not the same as right clicking in the sidebar. Sorry about that. Was able to make it work now. Thank you.