Skip to Content
0
Jan 23, 2017 at 09:53 AM

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

301 Views

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.