Help With Query Pls

[Former Member]

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 · Accepted solution]

Steve,

Use something like this:

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

Regards,

Nat