Symptoms

Error message "Incorrect Syntax near the keyword 'WHERE'" when using update method of the SQL smart object to pass NULL value into field of DateTime type.
 

Diagnoses

This is known issue which exist both in 4.6.7 and 4.6.8: Unable to pass NULL value when executing UPDATE method for DateTime format column of SQL Server SMO both from SmartObjects Services Tester and from the SmartObject Event in the workflow.

 

Resolution

This is known issue which is slated to be addressed in future versions of the product (post 4.6.9).