Issue with date format when importing data

Issue with date format when importing data

 When I import data into an existing form, the import defaults to assuming any date is in a dd-MM-yyyy format, and sets the format to MM-dd-yyyy if it detects that the date is invalid in dd-MM-yyyy format but is valid in MM-dd-yyyy format.

For example, if I import the following data:

Transaction Date Transaction Amount
9/5/2008 52.39
9/12/2008 31.43
9/16/2008 -75.59
9/19/2008 31.43
9/26/2008 52.39

Zoho puts the data into my form as:

5/9/2008 52.39
12/9/2008 31.43
9/16/2008 -75.59
9/19/2008 31.43
9/26/2008 52.39



I double checked that on the Form it indicates the date should be in a format of [MM-dd-yyyy] and that in my Application Settings I also have the format in [MM-dd-yyyy], therefore there is a bug in how an import of data into form with dates is treated.