select Products.prodname, sum( billdetail.Qty) as qty,BillDetail.rate,
sum(billdetail.amt) as Amt from billdetail
inner join products
on products.prodid = billdetail.prodid
inner join category
on category.catid = products.catid
inner join billmaster
on billmaster.BillID = BillDetail.BillID
where billmaster.billdate between 1/08/2017 and 19/09/2017 and CatName =
'chicken'
group by prodname,rate
My issue is when I include date parameters it stops working. How can I include them?
Dates and string literals should be enclosed between two
''
:Also it is recommended to use the iso standard format to format the values of these dates' values.