I have noticed that setting a dynamic date field from source column changes the time within the date. Can anyone confirm this?
For example, the document I import has the following xml field. <field name="original_air_date_d">2002-12-18T00:00:00Z</field> In my data-inport-config file I define the following instructions: <field column="temp_original_air_date_s" xpath="/add/doc/fie...@name='original_air_date_d']" /> <field column="original_air_year_s" sourceColName="temp_original_air_date_s" regex="([0-9][0-9][0-9][0-9])[- /.][0-9][0-9][- /.][0- 9][0-9][T][0-9][0-9][:][0-9][0-9][:][0-9][0-9][Z]" replaceWith="$1" /> <field column="original_air_date_d" sourceColName="temp_original_air_date_s" dateTimeFormat="yyyy-MM-dd'T'HH:mm:ss'Z'"/> What is set in my index is is the following: <arr name="temp_original_air_date_s"> <str>2002-12-18T00:00:00Z</str> </arr> <arr name="original_air_year_s"> <str>2002</str> </arr> <arr name="original_air_date_d"> <date>2002-12-18T05:00:00Z</date> </arr> You'll notice that the hour (HH) in original_air_date_d changes is set to 05. It should still be 00. I have noticed that it changes to either 04 or 05 in all cases within my index. In my schema the dynamic field "*_d" <dynamicField name="*_d" type="date" indexed="true" stored="true"/> Thanks, Wesley.