todate( left(date, len(date) -3)
https://help.fanruan.com/finebi/doc-view-1454.html 参考format函数
日期与字符串相互转化-https://help.fanruan.com/finebi/doc-view-1346.html