Date format error

[maxime.lambert]

Hi,

I don't understand why SugarCRM displays dates in two different format. It's better to look at these screenshots (from the same screen Contacts - DetailView)... First format is yyyy-mm-dd and second is dd/mm/yyyy. The first field corresponds to a custom field, and second one is 'date_entered' field.

Thanks...

[andopes]

Hi Lambert

What is the SugarCRM version you are using?
What is the date format for user you using?

Cheers

[maxime.lambert]

Hi andopes,

SugarCRM version is 5.2.0c and this is my config.php file :

[maxime.lambert]

Hi,

Actually, the first field (format yyyy-mm-dd) is a custom field, while the other one is not.
This is my detailviewdefs.php file :

 ...
3 => 
array (
  0 => 
  array (
    'name' => 'birthdate_c',
    'label' => 'LBL_BIRTHDATE',
  ),
),
... 
  

Can someone help me ?

Thanks...

[michel.d]

Hi!
I'd be glad to find an answer to this problem i'm working on with Maxime.

I give some additionals details in order to understand the problem:

Any original Sugar date field is correctly displayed in dd/mm/yyyy format, although the value in database is formatted in yyyy-mm-dd.
In contrary, our custom field date_c is displayed directly in database format.

I guess that there is something to do before display to get the same result for our custom field.

Our vardefs file looks like that:

 $dictionary["Module"]["fields"]["date_c"] = array (
    'required' => '0',
    'source' => 'custom_fields',
    'name' => 'date_c',
    'vname' => 'LBL_DATE',
    'type' => 'date',
    'massupdate' => '0',
    'default' => NULL,
    'comments' => '',
    'help' => '',
    'importable' => 'true',
    'duplicate_merge' => 'disabled',
    'duplicate_merge_dom_value' => '0',
    'audited' => 0,
    'reportable' => 0,
    'id' => 'Moduledate_c',
    'custom_module' => 'Module',
); 
  

And e.g. the field birthdate in Contacts:

 'birthdate' =>
        array (
            'name' => 'birthdate',
            'vname' => 'LBL_BIRTHDATE',
            'massupdate' => false,
            'type' => 'date',
            'comment' => 'The birthdate of the contact'
        ), 
  

I suppose that custom date fields are processed as String or something like that, but i wasn't able to found where...
If anybody could help, thanks by advance!