Unable to import Date from XML port to table.

Mohsin_abbas

Hi, I'm trying to fetch invoices through XMLPort and saving them in tables. All is going well except for the date where it says that '11-10-2016T 00:00:00' can not be saved in Date type field. In order to manipulate the date and make it compatible with 'Date' data type, I changed its datasource from 'field' to 'text' and then changed it to correct format using code in the trigger InvoiceDate -Import::OnAfterAssignVariable(). Now the error is removed but issue is, it does not insert the date in table field(field is left blank). What could be the possible reason?

Kishorm

As a guess, you are probably not assigning the value to the date field. You should really post your code if you want others to help you identify what is wrong with it.