How can I update with a blank date via the REST API?
Do I need to "allow NULL values" someplace?
I'm having trouble doing an upsert when I have a blank date value. I'm syncing with MySQL so it is stored there as "0000-00-00". I have a data clean up class, so I can convert it to whatever but nothing has worked (I've tried NULL, empty string, and '0000-00-00'). I always get a FIELD_INTEGRITY_EXCEPTION error.
Basically, I'm doing this in PHP, and I need to know what to return when I find either an empty or non-parseable date:
case 'date': if( $value == '0000-00-00' || strtotime($value) === false ) return NULL; return date("Y-m-d", strtotime($value)); break;