Date format problem

[Herryandi]

Hi all,

Im having date format in my ms sql server 2000
database. I always get a problem in inserting or updating
data because of my date format. Im taking the value of
date from textbox. This is how the code:

dim d as date
d = txtDate1.Text

and the sql string is like this

sqlStr1 = "INSERT INTO CONTACT Values( " & _
d.ToShortDateString & ",'" & txtName.Text
& "')"

The error is with the date format.
Anyone have any idea about this problem

Thanks

But

[Sparky Arbuckle]

What is the name of your Date Field in your database. I know that date
is a reserved word in Access.

Have you tried:

dim d as string

[Red]

You must save format as MM/dd/yyyy not dd/MM/yyyy

-----Original Message-----
What is the name of your Date Field in your database. I know that dateis a reserved word in Access.

Have you tried:

dim d as string

.

[Patrick Olurotimi Ige]

HerrYAndi
Guess it would be better if u write a stored procedure for ur SQl
insert!
Patrick


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!