Solr: org.apache.solr.common.SolrException: Invalid Date String?

Solr dates must be in the form 1995-12-31T23:59:59Z You're only giving the date part, but not the time See the DateField javadocs for more details.

Solr dates must be in the form 1995-12-31T23:59:59Z. You're only giving the date part, but not the time. See the DateField javadocs for more details.

Thanks for the response, actually what we need to achieve is see group by results based on dates like, 2011-01-01 23 2011-01-02 14 2011-01-03 40 2011-01-04 10 Now the records in my table run into millions, grouping the result based on UTC date would not produce the right result since the result should be grouped on users timezone. Is there anyway we can achieve this in Solr? – sesmic May 6 at 5:54 1 @rohitgu: you need to give Solr dates in this format for indexing.

There is no other way. So shift everything to UTC, and when you get back results shift back to whatever timezone is needed. – Mauricio Scheffer May 6 at 11:04.

Date faceting is entirely driven by query params, so if we index your events using the "true" time that they happend at (formatted as a string in UTC) you can then select your date ranges using whatever timezone offset is specified by your user at query time as a UTC offset. Facet. Range = dateField facet.range.

Start = 2011-01-01T00:00:00Z+${useroffset}MINUTES facet.range. Gap = +1DAY This would return result in the users timezone and there is actually no need to timezone conversion the query and indexing that column separately. Regards, Rohit Credit For Answer: Chris Hostetter (Solr User Group ).

Moreover, this answer is entirely unrelated to the exception in your own question! – Mauricio Scheffer May 10 at 19:16 I see you copied Chris Hostetter's answer in solr-user here, but that answer was to a different question... – Mauricio Scheffer May 10 at 19:38 forgot adding the credit.. have done so now. – sesmic May 10 at 19:43 "Why I am doing this timezone conversion is because I need to group results by the user timezone.

How can I achieve this? " the second part of my question was related to this.. sorry was not clear may be – sesmic May 10 at 19:50.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.