Searching for future or "null" dates

I'm having a lot of trouble getting this query syntax to work correctly. How can I search for a date, which is either in the future OR missing completely (meaning open ended) I've tried -endDate:[* TO *] OR endDate[NOW TO *] but that doesn't work. Adding parentheses doesn't help either. Any help

Re: AW: Searching for future or "null" dates

Christian Kolodziej wrote: > > Hi Chris, > >>I'm having a lot of trouble getting this query syntax to work correctly. >>How >>can I search for a date, which is either in the future OR missing >>completely >>(meaning open ended) >> >>I've tried -endDate:[* TO *] OR endDate[NOW TO *] but that do

Re: AW: Searching for future or "null" dates

Yes your right I mistyped when I said [* : *]. I did mean [* TO *] hossman wrote: > > > : present and have a end date in the present/future or none at all. I had > : looked into searching for null dates and had come across the -date[* : > *] > : syntax, which searches for the absence of the in

RE: Searching for future or "null" dates

Here is what I was able to get working with your help. (productId:(102685804)) AND liveDate:[* TO NOW] AND ((endDate:[NOW TO *]) OR ((*:* -endDate:[* TO *]))) the *:* is what I was missing. Thanks for your help. hossman wrote: > > > : If the query stars with a negative clause Lucene return

RE: Searching for future or "null" dates

Thanks I'll try it out. hossman wrote: > > > : Here is what I was able to get working with your help. > : > : (productId:(102685804)) AND liveDate:[* TO NOW] AND ((endDate:[NOW TO > *]) OR > : ((*:* -endDate:[* TO *]))) > : > : the *:* is what I was missing. > > Please, PLEASE ... do yourse