filtering searches or smart groups by date

[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

[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

[othoms]

Can this be done with smart groups?

[Jon]

That IS for a smart group (SQL).

Jon
Sonny Software

[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.