I am noticing in a unit test when ExcelReader' "Date Format" property is
configured with MM/dd/yy and the schema access strategy is configured with
"Infer Schema" that
a Excel spreadsheet which has a column of data which have dates without a
leading 0 in the month (e.g 9/18/18) is being inferred as a STRING and not
a DATE:MM/dd/yy. Only if the month is a double digit (e.g. 10/22/18) it is
being referred to as DATE:MM/dd/yy. Even if the "Date Format" is
configured with a single character for month (M/dd/yy) only the double
digit month is being inferred as a DATE:M/dd/yy and not the single digit
month. I am also seeing similar behavior when the day is a single digit
(e.g. 10/5/18) is being interpreted as a STRING and not a DATE:MM/dd/yy or
DATE:M/dd/yy.
This does not seem correct. Please advise.
