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 AmountZoho 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.