DateTime Custom Field ?

[spencer134]

First of all I'm new with SugarCRM so pardon me if I ask newbie question I did try searching for an answer but did not find one.

Is there a DateTime custom field? I can only see Date field when I try adding custom fields to Leads, Accounts, etc.
I'm looking at: Developer Tools > Studio

Thanks!

[mikesolomon]

First of all I'm new with SugarCRM so pardon me if I ask newbie question I did try searching for an answer but did not find one.

Is there a DateTime custom field? I can only see Date field when I try adding custom fields to Leads, Accounts, etc.
I'm looking at: Developer Tools > Studio

Thanks!

Not in studio but you can create one

I created my field as a time field but then went to vardefs & set it to be a datetime field

'date_start' =>
array (
'required' => false,
'name' => 'date_start',
'vname' => 'LBL_DATE_START',
'type' => 'datetime',
'massupdate' => 0,
'comments' => '',
'help' => '',
'duplicate_merge' => 'disabled',
'duplicate_merge_dom_value' => 0,
'audited' => 0,
'reportable' => 0,
'len' => '25',
),
I then changed the type in mysql to datetime

I also changed metadata/editviewdefs.php

array('name'=>'date_start', 'type'=>'datetimecombo','label'=>'LBL_DATETIME_STA RT',),

It's a bit fiddly but it works

Lastly because sugar makes datetime fields a drop down of hours & a dropdown of minutes in quarter hour intervals I edited include/SugarFields/Fields/DateTimecombo/Datetimecombo.js so that I can enter time in the format HH:MM

[lachmac]

Hi,

I implemented this in Sugar 5.5. It works, but I cannot get the field to save empty, i.e. if I leave the field empty it will save 2000-01-01 00:00.

Any ideas?

In your instruct I see that

Quote
I also changed metadata/editviewdefs.php

array('name'=>'date_start', 'type'=>'datetimecombo','label'=>'LBL_DATETIME_STA RT',),
Unquote

How come you label it 'LBL_DATETIME_STA RT and not just LBL_DATE_START?

Regards,

[datasponge]

I implemented this in Sugar 5.5. It works, but I cannot get the field to save empty, i.e. if I leave the field empty it will save 2000-01-01 00:00.

Any ideas?

Make sure your SQL field definition allows NULL and that the default (in studio and SQL) is empty or Null.

Not certain this is the only problem as your default date is odd, but Sugar behavior is that when a field is empty it fills in using the default.

Phil