Hello i have a field in solr <field name="cdStartDate" type="date" indexed="true" stored="true" /> i need to get all documents whose cdStartDAte is null and also if the cdStartDate is present then it should be from * TO NOW i added the fq condition ((*:* AND -(cdStartDate:[* TO *])) OR (cdStartDate:[* TO NOW]))
the issue its working fine except its only filtering document by date and not considering time. For example if today is March 9 2pm i get both the doc returns as you can see the second document date is March 9, 8m yet it comes up in search results any advice { "id": "9-MAR AT 7AM", "title": "testCD valid from March 9 8PM", "cdStartDate": "2014-03-09T07:00:00Z" }, { "id": "9-MAR AT 8PM", "title": "testCD valid from March 9 8PM", "cdStartDate": "2014-03-09T20:00:00Z" } -- View this message in context: http://lucene.472066.n3.nabble.com/Filter-query-not-working-for-time-range-tp4122441.html Sent from the Solr - User mailing list archive at Nabble.com.