Creating cstm field: type date, no default value

[gladiorlic]

HI,

I created a cstm field, type Date. If no date is entered the field should be blank.
Although i did specify that the default value is 'none', the system inserts the date 1900-01-01.

How do i bypass this? No dater entry must result in blank field.

[mwallace]

This doesn't happen on my version (4.5.1d). You can try this and maybe it will work with your version. Maybe not! This controls the default behavior for custom date entries that are blank or are 1900-01-01.

1. Go to sugarcrm\htdocs\sugarcrm\modules\DynamicFields and open DynamicFields.php.

2. In my version, line 223 has the default behavior for empty custom date fields. Here's what it I have:

if($field['data_type'] == 'date' && (empty($this->bean->$name )|| $this->bean->$name == '1900-01-01'))
{
$this->bean->$name = 'NULL';
}

3. See if you have code that is similar to this. Modify it or add it if you don't have anything like it. It changes empty date values and date values of 1900-01-01 to null, which is what you're after.

[umer]

please help me i am using vmware server and i have installed red hat enterprise i am occuring the p roblem of mysql database not available how can i remove this problem my php version is 4-4 and mysql version is 5