Recommend using the "pdate" format for faster range queries. Here's how (or one way) to do a range query in solr
defType=lucene&q=some_field:[1995-12-31T23:59:59.999Z TO 2007-03-06T00:00:00Z] Does that answer your question? I don't really understand what you're trying to do with your two dates. You can of course combine range queries with operators with the standard/lucene query parser: defType=lucene&q=some_field:[1995-12-31T23:59:59.999Z TO 2007-03-06T00:00:00Z] AND other_field=[whatever TO whatever] There are ways to make a query comparing the values of two fields too using function queries. But it's slighlty confusing and i'm not sure that's what you want to do, I'm not really sure what you want to do. Want to give an example of exactly what input you have (from your application), and what question you are trying to answer from your index? ________________________________________ From: nedaha [neda...@gmail.com] Sent: Monday, October 18, 2010 5:05 AM To: solr-user@lucene.apache.org Subject: Re: query between two date Thanks for your reply. I know about the solr date format!! Check-in and Check-out dates are user-friendly format that we use in our search form for system's users. and i change the format via code and then send them to solr. I want to know how can i make a query to compare a range between check-in and check-out date with some separate different days that i have in solr index. for example: check-in date is: 2010-10-19T00:00:00Z and check-out date is: 2010-10-21T00:00:00Z when i want to build a query from my application i have a range date but in solr index i have separate dates. So how can i compare them to get the appropriate result? -- View this message in context: http://lucene.472066.n3.nabble.com/query-between-two-date-tp1718566p1723752.html Sent from the Solr - User mailing list archive at Nabble.com.
