RE: query between two date

2010-10-18 Thread Jonathan Rochkind
at 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 ar

Re: query between two date

2010-10-18 Thread Savvas-Andreas Moysidis
ok, I see now..well, the only query that comes to mind is something like: check-in date:[2010-10-19T00:00:00Z TO *] AND check-out date:[* TO 2010-10-21T00:00:00Z] would something like that work? On 18 October 2010 11:04, nedaha wrote: > > The exact query that i want is: > > check-in date >= 201

Re: query between two date

2010-10-18 Thread nedaha
The exact query that i want is: check-in date >= 2010-10-19T00:00:00Z AND check-out date <= 2010-10-21T00:00:00Z but because of the structure that i have to index i don't have specific start date and end date in my solr index to compare with check-in and check-out date range. I have some dates

Re: query between two date

2010-10-18 Thread Savvas-Andreas Moysidis
ok, maybe don't get this right.. are you trying to match something like check-in date > 2010-10-19T00:00:00Z AND check-out date < 2010-10-21T00:00:00Z *or* check-in date = 2010-10-19T00:00:00Z AND check-out date = 2010-10-21T00:00:00Z? On 18 October 2010 10:05, nedaha wrote: > > Thanks for you

Re: query between two date

2010-10-18 Thread nedaha
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

Re: query between two date

2010-10-18 Thread Savvas-Andreas Moysidis
You'll have to supply your dates in a format Solr expects (e.g. 2010-10-19T08:29:43Z and not 2010-10-19). If you don't need millisecond granularity you can use the DateMath syntax to specify that. Please, also check http://wiki.apache.org/solr/SolrQuerySyntax. On 17 October 2010 10:54, nedaha wr