Hello i have come across many threads where people have asked how to fetch doc based on date comparison, my problem is pretty much on the same line. based on todays date i want to fetch documents which are live For example i have three doc below <doc1 liveDate=1-MAR-2014> <doc2 liveDate=1-APR-2014> <doc3 liveDate=1-MAY-2014>
i want to select only one doc based on todays date, hence if today is 14-APR and if i run query liveDate:[* TO 14-APR-2014] its getting two doc i want to get only the latest one which is doc2. Is there out of the box method which can solve my issue. In order to fix this issue i proposed to have doc liveStartDate and liveEndDate <doc1 liveStartDate=1-MAR-2014 liveEndDate=31-MAR-2014> <doc2 liveStartDate=1-APR-2014 liveEndDate=31-APR-2014> <doc2 liveStartDate=1-MAY-2014 liveEndDate=31-MAY-2014> Hence if today is 14-APR-2014 can i run a query where i can give a condition something like currentDate>liveStartDate AND currentDate<liveEndDate can someone please let me know how to do this kind of date comparison. thanks darniz -- View this message in context: http://lucene.472066.n3.nabble.com/Fetching-document-by-comparing-date-to-today-date-tp4130802.html Sent from the Solr - User mailing list archive at Nabble.com.
