Tableau编辑字段报错

Question

错误: 无法解析日期详情: Cannot parse date: value is too short. Note: there are toDateOrZero and toDateOrNull functions, which returns zero/NULL instead of throwing exception.: while converting '' to 'Date' (version 19.5.3.8)

公式：multiIf(toDateOrNull([实际到货时间])='', dateDiff(now(),[预计到货日期]),toDateOrNull([签收录入日期])='',dateDiff(today(),[实际到货时间]),dateDiff([签收录入日期],[实际到货时间]))

Answer 1

用到的三个时间字段都看一下数据内容吧，日期格式存在问题，应该是值太短了