Skip to Content
0
Sep 12, 2023 at 09:20 AM

I cant use date conditon in query

57 Views

I have 1 Question

- When I use where date condition it error " Unknow Column %0 " but if i use another Column example DocNum It not error

My Query below

SELECT

T10.[firstName],

T11.[U_NAME],

T0.[CardName],

T1.[ItemCode],

T1.[Dscription],

T1.[Quantity],

T1.[Price],

T1.[LineTotal],

T8.[TaxDate],

T0.[U_DatePOtoSup],

T0.[U_DeleveryDate],

T3.[U_DateRecSup],

T3.[U_DateQCRec],

T5.[TaxDate],

T8.[DocEntry],

T6.[DocNum],

T0.[DocNum],

T0.[TaxDate],

T5.[DocNum],

T5.[NumAtCard],

T1.[LineStatus]

FROM

OPOR T0

INNER JOIN POR1 T1 ON T0.[DocEntry] = T1.[DocEntry]

LEFT JOIN [dbo].[@PURCHASEHEADER] T2 ON T0.[Docnum] = T2.[U_PONo]

LEFT JOIN [dbo].[@PURCHASEDETAIL] T3 ON T2.[DocEntry] = T3.[DocEntry]

AND T1.[Itemcode] = T3.[U_Itemcode]

AND (T1.LineNum + 1) = T3.U_LineNo

LEFT JOIN PDN1 T4 ON T0.[DocNum] = T4.[BaseRef]

AND T1.[ItemCode] = T4.[ItemCode]

LEFT JOIN OPDN T5 ON T4.[DocEntry] = T5.[DocEntry]

LEFT JOIN OPRQ T6 ON T1.[BaseRef] = T6.[DocNum]

LEFT JOIN PRQ1 T7 ON T6.[DocEntry] = T7.[DocEntry]

AND T1.[ItemCode] = T7.[ItemCode]

LEFT JOIN ODRF T8 ON T6.[draftKey] = T8.[DocEntry]

LEFT JOIN DRF1 T9 ON T8.[DocEntry] = T9.[DocEntry]

AND T1.[ItemCode] = T9.[ItemCode]

LEFT JOIN OHEM T10 ON T8.[OwnerCode] = T10.[empID]

LEFT JOIN OUSR T11 ON T0.[UserSign] = T11.[USERID]

WHERE T0.[DocDate] >= [%0] AND T0.[DocDate] <= [%1]