'Data' format during table definition and data import

'Data' format during table definition and data import

Hi,

I have an excel file with a 'Date' column. The format of the date is dd/MM/yy.

In zoho db when defining a table,the default 'Date' format as MM/dd/yy. I go ahead and change it to dd/MM/yy so that it matches my excel file.

However, when I import data, zoho DB again defaults to the format MM/dd/yy and asks me to change it to the appropriate format. I have to change the date format to dd/MM/yy every time I import data.

If I defined the date format I require during the table definition, then why does it go back to standard zoho db default during data import?

Regards,
Nish