Whats wrong with this SQL insert

Here it is:

INSERT INTO discountFile( productID, startDate, startTime, endTime, endDate, weekly, discount, BOGOF, TreeForTwo) VALUES ( " & prodId & ", #" & startDate & "#, '" & startTime & "', '" & endTime & "', #" & endDate & "#, '" & weekly & "', " & disc & ", " & bogof & ", " & tft & " );


Thanks for looking.
:(

whats the error msg u get ?

I have now found out it is to do with date formating.

Dim startDate As String = Format dtpAdjEdtDiscStartDate.Text, "dd,mm,yyyy")


This seems to return at string containing "DDMMYYYY" not a date.

I have tried using a date instead of a String but I get a invalid cast exeption.

Thanks for helping (once again).

sorry the code is:


Dim startDate As String = Format(dtpAdjEdtDiscStartDate.Text, "dd,mm,yyyy")


(last one was missing bracket.)

Or you can format it like:
DateTime.Parse(dtpAdjEdtDiscStartDate.Text).ToString("MM/dd/yyyy")

-Cool Bizs