You haven't told us under what criteria you would exclude the March document. Do you want only docs that are in the current month? If so, date:[NOW/MONTH TO NOW/MONTH+1MONTH] should do it.
Best, Erick On Sat, Apr 12, 2014 at 4:08 PM, Furkan KAMACI <furkankam...@gmail.com> wrote: > Hi Darniz; > > Why don't you filter your documents that has a date until TODAY and then > sort them by date and finally get only 1 document with rows=1 ? > > Thanks; > Furkan KAMACI > > > 2014-04-13 0:08 GMT+03:00 Darniz <rnizamud...@edmunds.com>: > >> Thanks for the quick answer i was able to solve my problem with the >> addition >> of two new fields and if todays date is april14 my query is >> >> (liveStartDate:[* TO 2014-04-14T00:00:00Z] AND >> liveEndDate:[2014-04-14T00:00:00Z TO *]) >> >> and its fetches me the correct document >> >> guess my initial question does solr provide out of the box functionality if >> i have the below three documents set, how can i get only doc2 if i assume >> todays date is 14-APRIL-2014 >> >> for simplicity i gave the liveDate as dates beginning at the start of each >> month but in real life these dates can be anything. >> <doc1 liveDate=1-MAR-2014> >> <doc2 liveDate=1-APR-2014> >> <doc3 liveDate=1-MAY-2014> >> >> >> >> -- >> View this message in context: >> http://lucene.472066.n3.nabble.com/Fetching-document-by-comparing-date-to-today-date-tp4130802p4130807.html >> Sent from the Solr - User mailing list archive at Nabble.com. >>
