Excel import
Hi there
I encounter 2 errors during import of excel data.
1) Even though dates data is set correctly both on Excel an Zoho Creator side date field is not imported (see screenshots below)
2) Seems like Zoho modifies the value slightly during the import (see 10478..... value on the screenshots). Modification is very small, but for long numbers it results in import errors because of the length of the field.
Setup in Excel:
Date is not imported:
Date format is correct in Zoho
Value is modified (compared to Excel)
Import error because of the modified value:
I encounter 2 errors during import of excel data.
1) Even though dates data is set correctly both on Excel an Zoho Creator side date field is not imported (see screenshots below)
2) Seems like Zoho modifies the value slightly during the import (see 10478..... value on the screenshots). Modification is very small, but for long numbers it results in import errors because of the length of the field.
Setup in Excel:
Date is not imported:
Date format is correct in Zoho
Value is modified (compared to Excel)
Import error because of the modified value: