日期/时间格式的 excel sql vba 运行时错误 80040e07

日期/时间不匹配请帮助:(

" FROM HSL_RAW WHERE (((HSL_RAW.Partner)='MCC') AND " & _
    "((IIf([FirstName] Like 'Test%' Or [FirstName] Like '%Test' Or [FirstName] Like '%Test%'" & _
    "Or [EmailAddress] Like '%Test' Or [EmailAddress] Like 'Test%' Or [EmailAddress] Like '%Test%'" & _
    "Or [EmailAddress] Like '%AXA%' Or [EmailAddress] Like 'AXA%' Or [EmailAddress] Like '%AXA'" & _
    "Or [FirstName] Like 'sAMPLE%' Or [EmailAddress] Like '%sAMPLE%' Or [EmailAddress] Like '%sAMPLE'" & _
    "Or [EmailAddress] Is Null Or [EmailAddress]='%','Test','')) <>'Test')" & _
    "AND HSL_RAW.[DateCreated] >= '" & Range("H10") & "' and HSL_RAW.[DateCreated] <= '" & Range("H12") & "')" & _
    "GROUP BY 'Health Start Lite', HSL_RAW.Premium, HSL_RAW.LastName, HSL_RAW.EmailAddress, HSL_RAW.MobileNumber, HSL_RAW.Partner " & _
    "HAVING (((Max(HSL_RAW.DateCreated))>=DateSerial(YEAR(Date()),MONTH(Date()),1)) AND ((Last(Right([Stage],4)))<>'Paid'));"