I am trying to update a row in a table using a column of the data type Date in the update criteria. The update query doesn't work for me when the data type of the column in the update criteria is Date but works perfectly fine when I change the type to Plain Text.

Specifying update criteria as follows - 

"(EmailID = ' abc@xyz.com') and (\"newdate\" = '12 Sep 2016')"

I'm using this in Java and the specified date format is correct.

Please advise.

Regards,

Sagar