This insert stmt was generated by my VBScript program

"INSERT INTO InvoiceLine ( 

CustomerRefListID  ,

 RefNumber  ,

InvoiceLineItemRefListID  ,

InvoiceLineDesc  ,

InvoiceLineQuantity  ,

InvoiceLineServiceDate  ,

FQSaveToCache ) 

VALUES (

' 30000-1074158302',

'2006W000171',

'10000-1074158529',

'00000058 Kg      049 Days     574-3004 0850',

2842 ,

{d'9/8/2007'} ,

0 )"

with the following errors

Microsoft OLE DB Provider for ODBC Drivers (384, 17) : [QODBC] Expected lexical element not found: <identifier>

1. Is my inset stmt correct????

2. How do i convert my SQL server date format '9/8/2007' to QB data format '2007-8-9' ???

Thanks