Hi Experts,
I'm a newbie here and i'm seeking for your suggestions on how can i make use of a converted date in my where clause?? Is it possible?
Below is my sample query.
Thanks .
select t1.itemcode,t1.basecard, t1.Dscription, t1.Sales_Qty, t1.SDate
from
(
select a.itemcode,a.basecard, a.Dscription, SUM(a.quantity) 'Sales_Qty', CONVERT(CHAR(4), docdate, 100) + CONVERT(CHAR(4), docdate, 120) 'SDate' from INV1 A
group by CONVERT(CHAR(4), docdate, 100) + CONVERT(CHAR(4), docdate, 120), a.itemcode,a.basecard, a.Dscription
) t1
where t1.SDATE = '[%0]'