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