Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Help With Query Pls

Hello

I want to write a query which returns Sales Quotations within a date range ....ie

...................WHERE T0.DocDate BETWEEN [%0] AND [%1]

However if the two parameters are left blank I would want the query to return all Sales Quotations regardless of date.

Hope I have made myself clear?

Thanks

Steve

Former Member
Former Member replied

Steve,

Use something like this:

WHERE ((T0.DocDate >= '[%0]' and T1.DocDate <= '[%1]') OR ('[%0]' = '' and '[%1]' = ''))

Regards,

Nat

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question