Skip to Content
0
Former Member
Nov 28, 2009 at 07:12 AM

Query

12 Views

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