Skip to Content
0
Former Member
Jan 05, 2012 at 11:31 AM

error in query...

26 Views

hi SAP gurus,

i am writing a query that accepts date from user.

below is my query

/--this query is not getting executed...
Select opdn.docentry, opdn.cardcode, opdn.cardname, opdn.docdate
from opdn 
where opdn.docdate between '[%0]' and '[%1]'

i tried this too..

/--this query is not getting executed...
Select opdn.docentry, opdn.cardcode, opdn.cardname, opdn.docdate
from opdn 
where opdn.docdate between [%0] and [%1] 

simply putting my query is not accepting user input...

/-- this query is working fine..
Select opdn.docentry, opdn.cardcode, opdn.cardname, opdn.docdate
from opdn 
where opdn.docdate between '12/01/2011' and '12/31/2011'

the above query is working fine...

does any one have any idea about what's the problem with this simple query..?

i appreciate your help..

Thanks and Regards,

kaviprashu