A simple date range query does not really represent how people query over time and dates. If you want any form of date queries, above a single range, then a special field allowing tokenized query will be the only way to find documents.
A query for 'ever tuesday in november of 2017' would have to be written as an or clause over a set of date ranges. A tokenized date field would just have to query for "+nov +tues +2017". How you choose to tokenize a date into a field will determine the types of queries you can run over the data. Another part of this is query for a date range, when the source material has date ranges built into it is kinda odd. But it occurs. If you query from noon-1p does that include meeting notes which started at 1130a, but went for an hour? You have to choose what to do. tim On Thu, May 17, 2018 at 6:11 AM, Terry Steichen <te...@net-frame.com> wrote: > To me, one of the more frustrating things I've encountered in Solr is > working with date fields. Supposedly, according to the documentation, > this is straightforward. But in my experience, it is anything but > that. In particular, I've found that the abbreviated forms of date > queries, don't work as described. > > If I create a query like creation_date: [2016-10-01 To 2016-11-01], it > will produce a set of documents produced in the month of November 2016. > That's the good news. > > But, the abbreviated date queries (described in Solr documentation > <https://lucene.apache.org/solr/guide/6_6/working-with-dates.html>) > don't work. Tried creation_date: 2016-11. That's supposed to match > documents with any November 2016 date. But actually produces: > |"Invalid Date String:'2016-11'| > > ||And Solr doesn't seem to let me sort on a date field. Tried > creation_date asc Produced: |"can not sort on multivalued field: > creation_date"| > > In the AdminUI, if you go to the schema option for my collection, and > examine creation_date it show it to be: > org.apache.solr.schema.TrieDateField (This was automatically chosen by > the managed-schema) > > In that same AdminUI display, if I click "Load Term Info" I get a list > of dates, but when I click on one, it transforms it into a different > query form: {!term f=creation_date}2016-10-26T07:59:09.824Z But this > query still produces 0 hits (even though the listing says it should > produce dozens of hits). > > I imagine that I'm missing something basic here. But I have no idea > what. Any thoughts would be MOST welcome. > > PS: I'm using Solr 6.6.0. >
