Skip to Content

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

Approval query problem

Hi
,

Basically the problem is that my query is returning day instead of month...

Select MONTH($[OPOR.DocDueDate])


When I run this query on a PO with DocDueDate 22.05.14 (22nd of May) it will find that 22 is the month and give this error message:

Microsoft SQL Server - The conversion of a nvarchar data type to datetime data type resulted in an out-of-range-value

Any ideas?

BR
Kjetil Sandvik

replied

Hi,

Try this:

Select MONTH($[OPOR.DocDueDate.date])

Thanks & Regards,

Nagarajan

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question