I had made 1 Query in which Posting Date & Due is used in selection Criteria.........But it is not working it shows me an error of DateTime.
This was possible in SAP 2005 B .I have upgraded SAP to 2007 B PL 04.In 2007B it shows error.The working of company is effected bcoz of these........Is the methodology changed.
In selection criteria i have used the following Criteria(T0.DueDate >= '[%1]' and T0.DueDate <= '[%2]')
Rakesh Pati replied
Please use the following query to resolve the issue :
SELECT T0.DocNum, T0.Status, T0.U_Priority,
T0.DueDate, T0.PostDate, T0.ItemCode,
T0.PlannedQty, T0.CmpltQty, T0.RjctQty,
( T0.PlannedQty-T0.CmpltQty- T0.RjctQty) as
as 'Total Time Reqd',T0.U_TimeReq, T0.U_SHOP,
T0.U_FCName FROM OWOR T0 inner join wor1 t1 ON T0.DocEntry = T1.DocEntry WHERE (T0.Series = '31' or
T0.Series = '130') AND T0.Status = [%0] and
(T0.DueDate >= [%1] and T0.DueDate <= [%2])
or (T0.PostDate >= [%3] and T0.PostDate <= [%4])
and T1.ItemCode =[%7]
SAP Business One Forum Team