>When I try the quotes I get a message that the date syntax is wrong.

Use parameters. Boris showed the syntax. Although I'll move alltrim stuff out.

scatter memvar 
perform alltrim manipulations when needed
TEXT TO insertSImain NOSHOW PRETEXT 15 TEXTMERGE
     Insert Into webprddt7.qasimast(recseq, insptype, docno, partno,  shipsetid, dwgrev, vendorcode,
                                    faiindex, lotqty, sampletype, sampleqty, accptdqty, rejdqty, inspdate, inspector,
                                    inspsource, rejtindex)
     VALUES
	(?x,1, ?m.docno, ?m.partno,
         ?ALLTRIM(testconnQuery.jobno), ?ALLTRIM(testconnQuery.revision), ?ALLTRIM(testconnQuery.vendorcode),
         ?testconnQuery.faiindex, ?testconnQuery.lotsize, ?testconnQuery.sampletype, ?testconnQuery.cmss, ?testconnQuery.cmaa,
	 ?m.cmar, ?m..inspectdt, ?m.inspectsna,1, ? y)
ENDTEXT
? insertSImain
If SQLEXEC(testconn, insertSImain) <> -1 Then
   =SQLCOMMIT(testconn)
ELSE
    If Aerror(odbcerrormsg) > 0 Then
	MessageBox(odbcerrormsg(2))
    EndIf
EndIF

* Make extra needed changes