Help With Query Pls
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?
Use something like this:
WHERE ((T0.DocDate >= '[%0]' and T1.DocDate <= '[%1]') OR ('[%0]' = '' and '[%1]' = ''))