Skip to Content
0
Former Member
Nov 20, 2012 at 02:24 PM

Date in WHERE Section Not Functioning Properly

28 Views

Hello Experts...this is very strange...in SAP 2005 writing SQL:

I created some SQL which uses the ORDR.DocDate in the WHERE clause.

1. If I hard-code a date, it works (example T1.DocDate >= '09/01/12')

2. When I change the hard-code to a variable, it does not work (example T1.DocDate >= '[%0]'). It gives me a error message of (SEWSY).

3. I even tried to change it to T1.DocDate >= [%0] and that did not work...

Thanks in advance for your help...