Skip to main content
skender.kollcaku
Employee
Apr 30, 2023 12:50 PM UTC
Solved

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

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
Brainy
Apr 30, 2023 5:50 PM UTC

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

2 replies

stefanhelzle0001
Brainy
Apr 30, 2023 5:50 PM UTC

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

Known Participant
Mar 16, 2024 2:35 PM UTC

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