Multipe date format during CSV data import

Multipe date format during CSV data import

Hi,


I tried to import a CSV data file (can apply to MS Excel data files as well) where there are two date columns but different date formats.

One column had the dates formatted as "dd/mm/yyyy" while another column had the dates formatted as "dd/mm/yyyy hh:mm:ss".

When importing into Zoho, you can select a date format that translates any input column that meets the date format as a date data type. However, this would apply to one of the columns as it has data formatted as per Zoho date format specification while the other column with a different date format would be treated as a string.

Is it possible to specify data types including formats per column?

Thanks
Sunil