客户模块，“最新联系日期”显示格式错误
解决方法：
步骤：
1、打开navicat工具，找到灵当CRM数据库；
2、新建查询，复制下面的sql语句，并执行；
UPDATE (
SELECT
a.accountid,
max(a.contactdate) AS contactdate
FROM
ld_contactrecords a
WHERE
a.accountid > 0
GROUP BY
accountid
) a
INNER JOIN ld_account b ON a.accountid = b.accountid
SET b.lastcontactdate = date_format(a.contactdate, '%Y-%m-%d')
WHERE
a.contactdate > '1900-01-01';
SELECT
a.accountid,
max(a.contactdate) AS contactdate
FROM
ld_contactrecords a
WHERE
a.accountid > 0
GROUP BY
accountid
) a
INNER JOIN ld_account b ON a.accountid = b.accountid
SET b.lastcontactdate = date_format(a.contactdate, '%Y-%m-%d')
WHERE
a.contactdate > '1900-01-01';
