SQL_DML Error

Hi all;

I am in a problem with SQL_DML query in one of the messages

I have a query like <b>update table set field = 'Y' where date >= '$Date_min$' and date <= '$Date_max$'</b> i have taken Date_min and Date_max as key fields and both are of type datetime.

during the mapping in adpter it gives out an error like

<b>Syntax error converting datetime from character string</b>

Please help

Mudit