parsing Date() into database using SQL

[deano1]

Hi all,

Having a little problem parsing the current date from my vb.net app into access. Both formats are setup as date so i can't see problem. The date.todat format works but comes up with completely the wrong date im truying to use the date.now format. Heres the code see what you think.

Dim dDate As Date = Date.Now

cmd.CommandText = "INSERT INTO Faults (userName, userProblem, openDate) Values ('" & strUser & "', '" & strProblem & "', " & dDate & " ) "

Thanks In Advance!

[Bananafish]

Try This

Dim dDate As Date = Date.Now 
Dim strDate as String
 
strDate = dDate.Tostring("d MMM yyyy HH:mm:ss")
cmd.CommandText = "INSERT INTO Faults (userName, userProblem, openDate) Values ('" & strUser & "', '" & strProblem & "',  '" & strDate & "' ) "