This is my SQL statement:
query = "Update(tbl_shifts) SET StartTime=" & starttime & ", Endtime =" & endtime & ", TotalHours =" & totalhours & ", TotalPay=" & pay & ", Completed =" & True & "WHERE ShiftDate=" & DateTime.Today And "EmployeeName =" & EmployeeLogin.usersname
Upon the click of the button, it is supposed to add the variables (starttime, endtime, totalhours, pay) and tick the yes/no 'Completed
' field into the row of tbl_shifts
where the entry in the column 'EmployeeName
' matches the global variable 'EmployeeLogin.usersname
' and the entry in the column ShiftDate
(which is currently stored as DD/MM/YYYY HH:MM:SS
) matches DateTime.Today
(which is only DD/MM/YYYY
(I think)). What do I do to make my sql work as intended?