Hi everyone, I have an index that stores birth-dates, and I would like to search for anybody whose birth-date is within X days of a certain month/day. For example, I'd like to know if anybody's birthday is coming up within a certain number of days, regardless of what year they were born. How would I do this using Solr? As a follow-up, assuming this query is executed very often, should I maybe be indexing something other than the birth-date? Such as just the month-day pair? What is the most efficient way to do such a query?
Sincerely, Daryl.