Hi,

I have below openquery.
I am getting below error when I pass the date parameters to open query:
Msg 402, Level 16, State 1, Line 17
The data types varchar and date are incompatible in the add operator.

Is there any one to help me about this please?

My query is as follows;

DECLARE @ReportDate1 date
DECLARE @ReportDate2 date
DECLARE @TSQL varchar(8000)

set @ReportDate1 = (Select prevsun from CAS_Dates)
set @ReportDate2 = (Select sat from CAS_Dates)



SELECT @TSQL = 'select * from openquery (DB2,
''SELECT CAS_NUMBER, DIVISION_CODE, T53.DISTRICT,
T53.DSCH_TYPE, COUNT(*) AS TOTAL
FROM CSL.BCSLCLI T52, BIF.VBIF_BRANCH, CSL.BCSLPDM T53
WHERE REPORTING_NO = T53.BRANCH
AND T52.SEC_NUM = T53.SEC_NUM
AND T52.SEC_TYPE = T53.SEC_TYPE
AND DATE(T52.CHKLST_TS) >= ''''' + @ReportDate1 + '''''
AND T53.DSCH_TYPE <> ''0''
AND DATE(T52.CHKLST_TS) <= ''''' + @ReportDate2 + '''''
AND T52.CHKLST_ITEM = 101
AND BANK_NO = ''004''
GROUP BY CAS_NUMBER, DIVISION_CODE, T53.DISTRICT,T53.DSCH_TYPE
'')'



Thanks