title: Solr: org.apache.solr.common.SolrException: Invalid Date String:
body: <p>I am new to solr and this is my first attempt at indexing solr data, I am getting the following exception while indexing,</p>
  
  <blockquote>
    <p>org.apache.solr.common.SolrException: Invalid Date String:'2011-01-07'
    at org.apache.solr.schema.DateField.parseMath(DateField.java:165)
    at org.apache.solr.schema.TrieDateField.createField(TrieDateField.java:169)
    at org.apache.solr.schema.SchemaField.createField(SchemaField.java:98)
    at org.apache.solr.update.DocumentBuilder.addField(DocumentBuilder.java:204)
    at org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:277)</p>
  </blockquote>
  
  <p>I understand from reading some articles that Solr stores time only in UTC, this is the query i am trying to index,</p>
  
  <blockquote>
    <p>Select id,text,'language',links,tweetType,source,location,            bio,url,utcOffset,timeZone,frenCnt,createdAt,createdOnGMT,createdOnServerTime,follCnt,favCnt,totStatusCnt,usrCrtDate,humanSentiment,replied,replyMsg,classified,locationDetail,                         geonameid,country,continent,placeLongitude,placeLatitude,listedCnt,hashtag,mentions,senderInfScr,                           createdOnGMTDate,DATE_FORMAT(CONVERT_TZ(createdOnGMTDate,'+00:00','+05:30'),'%Y-%m-%d')  as IST,DATE_FORMAT(CONVERT_TZ(createdOnGMTDate,'+00:00','+01:00'),'%Y-%m-%d')  as ECT,DATE_FORMAT(CONVERT_TZ(createdOnGMTDate,'+00:00','+02:00'),'%Y-%m-%d')  as EET,DATE_FORMAT(CONVERT_TZ(createdOnGMTDate,'+00:00','+03:30'),'%Y-%m-%d')  as MET,sign(classified) as sentiment from </p>
  </blockquote>
  
  <p>Why i am doing this timezone conversion is because i need to group results by the user timezone. How can i achieve this?</p>
  
  <p>Regards,
  Rohit</p>