Update Query

[Shamli]

Hello Everyone
I am trying to update a table (specific column and row value) with the text box value in the form.

Text box carries a date value.

this is my query.

sSQL = "update EmpToProj Set EndDate = " & enddate & " WHERE EmployeeID = " & nMid & " AND ProjectID = " & nWid & ";"

The bold value is my textbox value.
Query runs.
But the updated value is this: 12:00:00 AM



I think there is a syntax error.
Not sure how to solve that.


Can anyone help me with this.

[Shamli]

Sorry. Solved it. Just noticed that I didn't set the text box as enddate in the query

Hello Everyone
I am trying to update a table (specific column and row value) with the text box value in the form.

Text box carries a date value.

this is my query.

sSQL = "update EmpToProj Set EndDate = " & enddate & " WHERE EmployeeID = " & nMid & " AND ProjectID = " & nWid & ";"

The bold value is my textbox value.
Query runs.
But the updated value is this: 12:00:00 AM

I think there is a syntax error.
Not sure how to solve that.


Can anyone help me with this.