Whats wrong with this SQL insert

[scottie_uk]

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.

[hellomadhu]

whats the error msg u get ?

[scottie_uk]

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).

[scottie_uk]

sorry the code is:


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


(last one was missing bracket.)

[coolbiz]

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

-Cool Bizs