HI All,
i am trying to make a query report where I also want to get the selection criteria of create date "to and from".. But this qury is returning error.
SELECT T0.[callID], T0.[createDate], T0.[U_branch], T0.[U_PurchasedFrom], T0.[U_ContactNo], T0.[U_Address], T0.[U_Territory], T1.[prblmTypID], T1.[Name], T1.[Descriptio], T0.[status] FROM OSCL T0 INNER JOIN OSCP T1 ON T0.problemTyp = T1.prblmTypID
in this I need,
where T0.[createDate] >= [%0] and T0.[createDate] <=[%1]
Thanks in advance,
Joseph