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