An SQL question .

[lirlir]

I want inserting to a table a Date !!
I wrote the following statement :

"INSERT INTO Projects (PNKey,Description,StartDate,EndDate) VALUES ('1','my date'," & mskStartDate.Text & "," & mskEndDate.Text & ")")

Is there any particular way to send Date value to a table ?

[MrShickadance]

Yes.. you have to enclose the date in curly braces {<date>}

[Lyla]

Yes. you have to enclose the date in Pound Sign #<date>#

# mskStartDate.Text # "," # mskEndDate.Text #


I think !