Hi, I have this problem: We have about 100k persons with date of birth indexed by solr. Now we need find persons with birth anniversary for any input date. Exactly 1, 5 and 10 year is neccessary.
For example: Input date: 17.8.2011 Required output: 1 year: persons with date of birth 17.8.2010, 17.8.2009, ..., 17.8.879, ... 5 year: ... date of birth 17.8.2006, 17.8.2001, ..., 17.8.1006, ... 10 year: 17.8.2001, 17.8.1991, ..., 17.8.891, ... My first idea was to index date in yyyymmdd format (20110817) and use modulo: 1 year: indexed_date % 10000 = 0817 5 year: indexed_date % 50000 = 10817 10 year: indexed_date % 100000 = 10817 but I didn't found something like modulo function in solr... Is there any simple solution for this problem? I'm just beginner in solr, so maybe I missed something. Thanks for any help! P.S: I'm sorry for my bad english. -- View this message in context: http://lucene.472066.n3.nabble.com/Periodic-search-in-date-field-tp3260793p3260793.html Sent from the Solr - User mailing list archive at Nabble.com.
