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!