Skip to Content
0

How to use DocDueDate (Delivary Date) in User Defined Values in SAP B1 9.2?.

Jan 23, 2017 at 09:53 AM

60

avatar image

Hi all,

How to use DocDueDate (Delivary Date) in User Defined Values

Actually my query works fine, but if I include the following in where clause T3.DocDueDate=(select $[OPOR.DocDueDate]) (T3 is ORDR table) it gives me the following error message

1).[Microsoft][SQL Server Native Client 10.0][SQL Server] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. "(WLS1)

I think the date format I have in delivary textbox 23/01/2017 does not match with DocDueDate in database.

How can I solve that the problem?

Please anyone can help me.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
DIEGO LOTHER Jan 23, 2017 at 12:06 PM
0

Hi Rurangwa,

Try this:

T3.DocDueDate=(select $[OPOR.DocDueDate.DATE])

Or just

T3.DocDueDate= $[OPOR.DocDueDate.DATE]

Hope it helps.

Kind Regards,

Diego Lother

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you so much.

0