Hi All,
I have made an UDF at title level named priority and set values as High, Medium and Low. When we make a sales order, we set the priority as well. Now the customer wants a query where he can get the details of number of sales quotations made within a week and two weeks range and that too based on the priority i.e the report should show the Highest priority Sales quotation first and so on. I have come up with an SQL but i dont know how to get the date range i.e week range and how to set the report according to the priority level. Can anyone please suggest how to correct this query;
SELECT T0.[CardCode], T0.[CardName], T1.[CntctPrsn], T0.[DocDate], T0.[DocDueDate], T0.[DocNum], T0.[U_Priority] FROM OQUT T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode
Thanks in advance,
Joseph
Edited by: Joseph Antony on Mar 5, 2009 11:32 AM