Filter1 = Filter1 & "{合同记录}.日期 < '" & .Value & "'"
改成这样看看
Dim d as Date = .Value
Filter1 = Filter1 & "{合同记录}.日期 < '" & d.Adddays(1) & "'"