Custom Date Field Default Value

[CMTG]

I created a custom date field with a default value of "-none-", yet it keeps using a default value of 1900-01-01 where I'd like the field to be empty or NULL instead.

I've inspected the fields_meta_data table and the default_value column says "-none-" like it is supposed to, so where can the 1900-01-01 value be coming from?

Thanks for any clues.

[Angel]

I believe this value is coming from the date validation in the sugar_3.js javascript, located in <sugar root>/include/javascript/

[CMTG]

Thanks for the hint, I'll look into it first thing Monday. ;-)

[CMTG]

After some digging, it turned out not be coming from any javascript. It seems to be an issue with MSSQL Server 2005. Sugar is correctly trying to insert an empty string into the database, but the database silently converts it into a valid date. :-(

I've worked around it by hacking at DynamicFields/DynamicField.php.

[sidh211]

Hi i am also facing the same issue

can you plss help me out

regds
sid