Dear agan2x yg baik hati rajin menabung, dan tidak sombong...ane ada kendala di program ane nich gan..

Conversion failed when converting date and/or time from character string

nich dia penampakn nya gan


dan ini source nya

Call koneksi()

 strsqlfak = "insert into tbl_faktur values('" & nofak.Text & "','" & String.Format(dttgl.Value, "MM-dd-yyyy") & "','" & txtkdtrans.Text & "','" _

 & txtbno.Text & "','" & "" & "',NULL,'" & String.Format(dtvaluta.Value, "MM-dd-yyyy") & "','" & txttempo.Text & "','" _

 & CLng(txtsubunit.Text) & "','" & CLng(txtsubdisc.Text) & "', '" & CLng(txttotalppn.Text) & "','" & CLng(txtpnbm.Text) & "','" _

 & CLng(txtsubvat.Text) & "','" & CLng(txtsubtotprice.Text) & "','" & "0" & "')"



 cmd = New SqlCommand(strsqlfak, con)

 cmd.Execute

NonQuery()

mohon agan2x bantu yaa...