Netsuite date format handling while its '00-00-0000' or null

  • 79Views
  • Last Post 22 August 2022
Integration pramata posted this 17 August 2022

Hi Skyvia team,


We are facing some issue while pushing data to netsuite. we are receiving the error in the data import package.

The error is appearing only for date field columns wherever the date column has '00-00-0000' or null value skyvia taking the values as 01/01/0001 which is not getting accepted by Netsuite system.

Please suggest how can we handle this issue.

package used :


Thanks & Regards

Attached Files

Nataliia Nikulina posted this 22 August 2022


Thank you for contacting Skyvia Support team.

As we can see there are several DT_DBDATE fields in your target MySQL database and for them, you receive invalid values 1/1/0001 or maybe nulls that are not accepted by NetSuite. 

We recommend that you do one of the following - either check these fields in the MySQL database and adjust them or compose more complex expressions to validate invalid values. 

Should you have any further questions, let us know. 

Best regards,