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

[former_member183402]

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.

[former_member185682 · Accepted solution]

Hi Rurangwa,

Try this:

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

Or just

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

Hope it helps.

Kind Regards,

Diego Lother

[former_member183402 · Accepted solution]

Thank you so much.