I am trying to migrate data from salesforce to sugarCRM. When importing activities to SugarCRM, the date is entering wrong. The problem we identified is it takes the day value of date as month value. So if the day value is greater than 12, it takes the value as invalid month and so an invalid date. Here the date will be entered as '1-1-1970'.
The different date formats we have tried are:-
Format Result
================================================== ==========
YYYY-MM-DD invalid /Skipped
YY-MM-DD invald/skipped
MM/DD/YYYY invalid skipped
etc.. we have tried many combinations of the same and all skipped. When try MM-DD-YYYY format , it takes the dates with a day value upto 12.All others skipped. ie day value was taken as month. Those dates that accepted were converted like ,month value of date incremented by 1 and day value decremented by 1.

When we try DD-MM-YYYY format, all accepted . but the dates with day value greater than 12 are saved as '1-1-1970'. Others converted like ,day value incremented by 1 and month value decremented by 1.

All these happened in the Sugar CRM professional edition. In the community edition, all values enterd cleanly with MM/DD/YYYY format. Then what is the issue with the professional edition.

Pls post your suggestions asap.

Thanks in advance.