Resolved "Operand type clash: int is incompatible with date" by using sql CONVERT function.

convert(datetime,@{variables('date_value')});