write date in custom field (PHP)

[Benjamin C. B.]

Hi,

I need to create/update some leads with date values that are stored in custom fields.
Here is how I try to do it :

 <?php
if(!defined('sugarEntry'))define('sugarEntry', true);
require_once('include/entryPoint.php');
require_once 'modules/Leads/Lead.php';
 
 
$lead=new Lead();
$lead->birth_date_c=date('Y-m-d H:i:s', strtotime('12/31/1976'));
echo 'before :'.$lead->birth_date_c."<br>\n";
$lead->save();
echo 'after :'.$lead->birth_date_c;
?>  

But id doesn't work. I get this :

before :1976-12-31 00:00:00
after :

and in SugarCRM, the lead is created with 2000-01-01 in the birth_date_c field.

Can someone tell me what's wrong with this code ?
thanks !

[sts]

How did you define the custom field "birth_date_c" in Studio? Or did you want to set the value of the standard field "birthdate"?

[Benjamin C. B.]

The dirth_date_c is a Date field, created in the studio.
And I can't find in the Studio the standard birthdate field...

[Angel]

I was thinking the same, is it defined as a DATE field or DATETIME field? If the former, that would explain the problem as you should only pass the date part in that case.

Also, the 'AFTER' line in your debug process is fine, as it happens after the record is saved to the Leads module, thus, the record is no longer loaded.

[Benjamin C. B.]

In the database, it's a DATETIME column. But in SugarCRM it's called a DATE field (since DATETIME is not a field type in SugarCRM).
Still, I tried to replace :
$lead->birth_date_c=date('Y-m-d H:i:s', strtotime('12/31/1976'));
by
$lead->birth_date_c=date('Y-m-d', strtotime('12/31/1976'));

and it doesn't work either.
By the way, I have many custom DATE fields in SugarCRM, some with a column DATE in the database, others with ta column DATETIME. How come they don't have the same column type ?

Thanks for your help !

[Benjamin C. B.]

Can nobody help me ?

[ldd-silver-ziegler]

use the sugar timedate object for this.

e.g.

 global $timedate;
$timestamp=time();
$formatted_date_time=date($timedate->get_date_time_format(), $timestamp);