Actually you don’t have to add another field - there is function ms that converts date to timestamp. What you can do is use frange query parser and play bit with math, e.g. sub(ms(date_field),ms(NOW/YEAR)) will give you ms elapsed since this year and you know that from 0 to 31*86400000 is January, from 31*86400000+1 to … is February and so on.
If you go this path, I would suggest custom function that will convert date to month/year. HTH, Emir -- Monitoring - Log Management - Alerting - Anomaly Detection Solr & Elasticsearch Consulting Support Training - http://sematext.com/ > On 14 Mar 2018, at 10:53, Albert Lee <albertlee8...@gmail.com> wrote: > > I don’t want to add separate fields since I have many dates to index. How to > index it as timestamp and do function query, any example or documentation? > > Regards, > Albert > > From: Emir Arnautović > Sent: Wednesday, March 14, 2018 5:38 PM > To: solr-user@lucene.apache.org > Subject: Re: solr query > > Hi Albert, > The simplest solution is to index month/year as separate fields. Alternative > is to index it as timestamp and do function query to do some math and filter > out records. > > Emir > -- > Monitoring - Log Management - Alerting - Anomaly Detection > Solr & Elasticsearch Consulting Support Training - http://sematext.com/ > > > >> On 14 Mar 2018, at 10:31, Albert Lee <albertlee8...@gmail.com> wrote: >> >> NOW/MONTH and NOW/YEAR to get the start of month/year, but how can I get >> current month of regardless year. Like the use case, people who’s birthdate >> is this month? >> >> Regard, >> Albert >> >> >> From: Emir Arnautović >> Sent: Wednesday, March 14, 2018 5:26 PM >> To: solr-user@lucene.apache.org >> Subject: Re: solr query >> >> Hi Albert, >> It does - you can use NOW/MONTH and NOW/YEAR to get the start of month/year. >> Here is reference to date math: >> https://lucene.apache.org/solr/guide/6_6/working-with-dates.html#WorkingwithDates-DateMathSyntax >> >> <https://lucene.apache.org/solr/guide/6_6/working-with-dates.html#WorkingwithDates-DateMathSyntax> >> >> HTH, >> Emir >> -- >> Monitoring - Log Management - Alerting - Anomaly Detection >> Solr & Elasticsearch Consulting Support Training - http://sematext.com/ >> >> >> >>> On 14 Mar 2018, at 04:21, Albert Lee <albertlee8...@gmail.com> wrote: >>> >>> Dear Solr, >>> I want to whether solr support query by this year or this month? >>> If can, how to do that. >>> Thanks. >>> >>> Regards, >>> Albert >>> >> >> > >
