Skip to Content

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

Regarding Query

Hi Experts,

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]')

Regards-

Mona.

replied

Hi Mona,

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

'Open Qty',T0.U_TimeReq,

(((T0.PlannedQty-T0.CmpltQty- T0.RjctQty)*T0.U_TimeReq)/60)

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]

Regards,

Rakesh Pati

SAP Business One Forum Team

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