In reply to: mshahnawaz
As you suggested , i cast the fields as datetime but still the same issue, please see the attachments.
There should be no need to cast WFD_AttDateTimeX, as this column is defined as datetime in the table.
Error comes from the fact, that you are passing value from form, which is not in format, that SQL understands.
Instead of using text of form value - choose ISO - it will provide the value in format, that you should be able to convert do datetime (attached screenshot).
I've also noted, that you have hard coded column names WFD_AttDateTime1/2 and WFD_DTYPEID=17 - consider using objects pane, pick values/columns from there, to avoid troubles when importing to new environments. In some cases you might end up with same attribute using different column in each environment.