[jboss-jira] [JBoss JIRA] Commented: (JBRULES-3154) Date handling in XLS tables

Date handling in XLS tables --------------------------- Key: JBRULES-3154 URL: https://issues.jboss.org/browse/JBRULES-3154 Project: Drools Issue Type: Feature Request Security Level: Public(Everyone can see) Components: drools-decisiontables Affects Versions: 5.2.0.Final Reporter: Michael Anstis Assignee: Michael Anstis Dates set in a XLS sheet are not read correctly under Guvnor. It seems that XLS reading transforms the date into a format that can't be properly handled by compiler. Example (in the repository_export.xml attached file) : * My XLS has a column that tests a java.util.Date against a value : "myDate >= $param" * My XLS cell contains a date, formatted by Excel (may be that's the reason) using a English format like the Guvnor default one, ie : dd-MMM-yyyy. The example date value is "01-Jan-2009" (the display, the internal value in XLS is a number...) Problems (at compilation and DRl generation) : * Unable to create a Field value of type 'ValueType = 'Date'' and value '"1-janv.-2009"' : notice that the date value has been transformed ! * This value ("janv." instead of "jan") is certainly due to the fact that I am french ("janvier" is the french for "january") * If I reset the french default format, ie dd/MM/yyyy, the value 01/01/2009 is tranformed to 01/01/09, and the compilation complains about unknown format (same error). * If I turn the excel cell in text format, and enter "01-jan-2009", there no value transformation anymore, and the rule compiles OK. So I guess that reading dates in the XLS is the source of the problem.