Syntax error on date input

Ok I have a page for work I'm trying to make. I have an input page using html forms on an ASP page. These forms are added to my mdb using another asp page. For clarification the input page is index.asp, the sql insert script is on addcase.asp and then I can view the results on showall.asp

Anyway everything worked fine until I tried to add the date. I keep getting syntax error on line 17 and 26 of my add case page...
here's what they say..

line 17 - date = ChkString(Request.Form("date"))

line 26 - con.Execute sql_insert

As I said it worked fine until I added the date part...I tried changing date to dateentered everywhere (including my db) and it quit giving me an error but I still get an error on line 26...

my actual sql insert script is on line 21..

line 21 - sql_insert = "insert into cccmtech (dslruid, techname, wtn, modem, dateentered, probdescr) values ('" & dslruid & "', '" & techname & "', '" & wtn & "', '" & modem & "', '" & dateentered & "', '" & probdescr & "',)"



The only other thing if it's not actually in one of those is in my input..I have the form for my date input put as:

Date (Please use mm/dd/yyyy): <input name="dateentered" type=text><br>

Can someone please help me figure this out?

Thanks..

found the problem...

Forgot to add the change in dateentered in the dim statement..

thanks all.