CiviCRM Community Forums (archive)

I'm running 2.0.5 and trying to create a bunch of contacts using the API's civicrm_contact_add function. Everything OK except for a custom field set up as a Date field that I'm trying to add data to.

The problem is I can't get the date value formatted properly. Each one I've tried results in the custom field value showing up in CiviCRM as 0th, 0 and in the database table as 0000-00-00 00:00:00.

$params = array(
  "contact_type"  => "Individual",
  name, address, etc.
  "custom_10" => $regdate
  );
$contact =&civicrm_contact_add($params);

Here are formats I've tried:

YYYYMMDD
YYYY/MM/DD
YYYY-MM-DD
YYYYMMDD
YYYY-MM-DD 00:00:00
unix timestamp (integer)

Some of those (YYYYMMDD) result in a "is not of type Timestamp" non-recoverable error, but the others don't report any errors. They just don't get recorded right.

Quick example to spell out the code associated with YYYYMMDDhhmmss, which works in 4.x. 

Here's a snippet I took from a hook_civicrm_post() and generalized for example, wherein I needed to save a date to a custom date field.

*Moderator: Would have used the code tokens, but getting bug "Sorry, you are not allowed to post external links."

// If you're moving a date from one place to another, strtotime() for timestamp;
// $ts = strtotime($values['contribution.recent_date']);
$ts = time();
$date_to_save = date("YmdHis", $ts);
$custom_field_id = 5;
// Get this from whatever objects passed to the hook;
// $contact_id = $objectRef->contact_id;
$contact_id = 1234;

$customParams = array("entityID" => $contact_id,
  "custom_$custom_field_id" => $date_to_save,
);

require_once 'CRM/Core/BAO/CustomValueTable.php';
CRM_Core_BAO_CustomValueTable::setValues( $customParams );