values in german and UK format cannot be saved

Hy,

Currently it isn't possible to save a value, when user use the new german date format. And I suppose it happens with UK format, too. Reason for this is the implementation in getValidDBInsertDateValue function. (https://code.vtiger.com/vtiger/vtigercrm/blob/master/include/utils/utils.php#L1786)

At first format "dd.mm.yyyy" will be converted to "dd-mm-yyyy" and then parsed as "yyyy-mm-dd". But input is "01.03.2020" and not "2020-03-01". So result will be an empty value, which is stored in database.

Because convertToDBFormat function in DateTimeFields class was extended to support every custom format, the solution already was implemented in their Commit, but not used in CRMEntity.

Merge Request: !544 (closed)