Very slow query on new custom module

[rsp]

Conversion of 2018-08-04 23:44:59 from user format d/m/Y h:ia failed

I had a similar issue with using Workflows. When I saved an object into Opportunoties workflow was executed. Seems like workflow module is expecting date with DBFormat SQL Date. I fixed by adding one more attempt to convert date if it fails. Modify file legacy/include/TimeDate.php public function fromUser($date, User $user = null) { $res = null; try { $res = SugarDateTime::createFromFormat($this->get_date_time_format($user), $date, $this->_getUserTZ($user)); …