Insert date value into Access DB

[mclueless]

I am really pissed with this date problem. please help me out.....

Public rs As New ADODB.Recordset
Private Sub Command1_Click()
 
Call connection
Set rs = New ADODB.Recordset
rs.Open "INSERT INTO DateTry(Date,Name) VALUES('" & Text1.Text & "','" & Text2.Text & "')", con, 3, 3
con.Close
 
End Sub

Plzzzzzzzzzzzzz Help!!!!!!!!!!!

[mclueless]

It gives SYNTAX ERROR IN INSERT INTO STATEMENT error.....

[QVeen72]

Hi,

What is your Database....?

REgards
Veena

[debasisdas]

Why you are using INSERT INTO while opening a record set ?

[lotus18]

Hi

You cannot make Date as your field name. And if you want to insert date, it should be enclosed it with #.

Public rs As New ADODB.Recordset
Private Sub Command1_Click()
 
Call connection
Set rs = New ADODB.Recordset
rs.Open "INSERT INTO DateTry ([MyDate],[Name]) VALUES(#" & Text1.Text & "#,'" & Text2.Text & "')", con, 3, 3
con.Close
 

Rey Sean
.

[mclueless]

I am using access....

[Killer42]

Possibly you can use Date as a field name, I'm not sure. But it's a really bad idea.

As lotus18 pointed out, you need to use # delimiters around the date value in your SQL string. What he didn't mention is that the value must be in American format - that is, mm/dd/yyyy. You might be able to get away with using a different format, as long as there's no way the day and month can be confused - for example #01-Feb-2008#. If you try to use dd/mm/yyyy format, it will only work when the day is higher than 12 so Access can't mix up the day and month.

I think debasisdas also raised a valid concern.