You can use DateMath as: date_field:[NOW TO NOW+45DAYS]
On Wed, Jan 7, 2009 at 3:00 PM, prerna07 <pkhandelw...@sapient.com> wrote: > > Hi, > > what will be the syntax of this sql query > SELECT * FROM table WHERE date > SYSDATE and date <SYSDATE+45 > in solr format ? > > I need to fetch records where date is between current date and 45 days > from > today. > > Thanks, > Prerna > -- > View this message in context: > http://www.nabble.com/Solr-query-for-date-tp21327696p21327696.html > Sent from the Solr - User mailing list archive at Nabble.com. > > -- Regards, Akshay Ukey. Enjoy your job, make lots of money, work within the law. Choose any two. -Author Unknown.
