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.