Call myCon.Execute("INSERT INTO BloodInventory (ProductID, locations, RBC,PhenotypeReserve, CMV, IRR, AverageDailyIssues, " & _
"DaysRemaining, SDLPF, TWLPF, FilteredApheresis, UserName,Scan, address, FilteredPaediatric, TimeEntered) VALUES (" & _
BuildString(unescape(Request.QueryString("ProductI D").Item)) & ", " & _
BuildString(unescape(Request.QueryString("location s").Item)) & ", " & _
BuildString(unescape(Request.QueryString("RBC").It em)) & ", " & _

BuildString(Format(left(Request.QueryString("DATE" ).Item, 2) & "/" & mid(Request.QueryString("DATE").Item, 2, 2) & "/" & Right(Request.QueryString("DATE").Item, 4), "dd MMM yyyy") & ", " & _


BuildString(unescape(Request.QueryString("CMV").It em)) & ", " & _
BuildString(unescape(Request.QueryString("IRR").It em)) & ", " & _
BuildString(unescape(Request.QueryString("AverageD ailyIssues").Item)) & ", " & _
BuildString(unescape(Request.QueryString("DaysRema ining").Item)) & ", " & _
BuildString(unescape(Request.QueryString("SDLPF"). Item)) & ", " & _
BuildString(unescape(Request.QueryString("TWLPF"). Item)) & ", " & _
BuildString(unescape(Request.QueryString("Filtered Apheresis").Item)) & ", " & _
BuildString(Request.Cookies("Login").Item) & ", " & _
BuildString(unescape(Request.QueryString("Scan").I tem)) & ", " & _
BuildString(unescape(Request.QueryString("address" ).Item)) & ", " & _
BuildString(unescape(Request.QueryString("Filtered Paediatric").Item)) & ", GetDate())"))

Call myCon.Close



I was hoping somebody can help me with the highlighted code, I am trying to be able to save date that gets scanned into my web page into ddmmyyyy format so I am trying to format that before the insert but I get type mismatch error for Format function, am I not using it properly? Don't worry about BuildString it is a function that my senior programmer created,it wouldn't affect it.