: For instance: A document with a start_date of 1/1/08 and an end_date : of 3/1/08 should still match for a search of the range 2/1/08 to : 2/2/08.
if I'm understanding you correctly, what you want is something like... startDate:[* TO NOW+30DAY] AND endDate:[NOW TO *] ..that should give you all documents where the document's start/end range overlaps with the range of NOW to NOW+30DAYS. although to more explicit i would write that as... +startDate:[* TO NOW+30DAY] +endDate:[NOW TO *] ...and then i'd wonder if "30 days" is really what i want, or if i actually want a month, and i was just assuming 30 days, so i'd then use... +startDate:[* TO NOW+1MONTH] +endDate:[NOW TO *] ...and because millisecond granularity is almost never that important, i would then change it to... +startDate:[* TO NOW+1DAY/DAY+1MONTH] +endDate:[NOW/DAY TO *] -Hoss