My application is in VB 6 and am using an Oracle database behind it. I am trying to run the following sql update statement using variables in vb. I keep getting an error when it tries to insert the date (finish = '" & aTask.Finish & ). If I take out the part w/ the dates, my database record updates fine. I've tried using the to_date function and several other methods but can't seem to fix it. Any ideas? And for example, when I run debug and mouse over the aTask.Finish variable the date format that shows is 5/25/2007 5:00:00 PM

m_Connection.Execute ("update tblprojectschedule set TaskName='" & aTask.Name & "'" & ", ComplePercent='" & aTask.PercentComplete & "'" & " " & ",finish = '" & aTask.Finish & "', where ctwprojno = '" & IndivProjectFileName & "'" & " " & "And relno = '" & aTask.Text9 & "'")