How to use converted date in where clause??

[User001]

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]'

[Gothmog]

That's not an OpenSQL statement, and seems to come from this mysql forum.
Is it SAP-related ?

[User001]

Yes, it is SAP related. I executed it through query generator. Without where clause the code gives output but when i added the where clause with the above condition it gives error.

[Gothmog]

Query generator? Looks like a SAP Business One tool.
I have no acces to a B1 system, sorry - ABAP uses a different syntax for the available SQL instructions (OpenSQL).

[User001]

yes it is tool for SAP B1. Ow, did i posted a question to a wrong forum? where should i go?
thanks

[Gothmog]

Well, it's more an SQL question than an ABAP one.
I can shadow this topic in the Business One subforum, if you want.

[User001]

Thanks for helping.. very much appreciated. I'll be the one to post it to the B1 subforum..
thank you