You need to sign in to do that
Don't have an account?
JustinC
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?
mtbclimber
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".