function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
JustinCJustinC 

Apex Data Loader - Bulk API - Issues with nulls & date fields

I am trying to insert/update a null value into a date field using the Apex Data Loader using the Bulk API mode.

 

The documentation for Bulk API says that blanks are skipped in the CSV file, so you must insert a #N/A into the field if you want to null that field.

 

This works fine for most fields, except when using #N/A on a date field, the Apex Data Loader fails to update any rows that use #N/A for date fields and the error log reports:

Error converting value to correct data type: Date Conversion FAILED

 

Has anyone encountered this issue? Is there a workaround for it?

mtbclimbermtbclimber
Apologies for our ambiguous naming, the "Apex Data Loader" actually has nothing to do with "Apex Code" which is the board this post was originally associated.  Moved to "General Development".