Receive "Incorrect datetime value: 'NULL' for column..." when importing Excel into database

Question

Hi all,
I am loading thousands of rows in a sync-enabled record through Import Excel into database plugin.
How to deal with errors from process execution when trying to import date/time Excel columns with no current date (or Null). Is it any alternative rather than inserting a default date/time value?

Thank you for any suggestion,

stefanhelzle0001 · Accepted Answer

The only options you have is to insert NULL or make that field accept NULL values, or the current date.

venkatesanr7469 · Answer

Do you find any solution for this i used 0000-00-00  it works , however that is the workaround , how can we make the date as null in appian , i could not able to figure out

Sign up

Login with SSO

Login to the community

Login with SSO