asp date() to SQL Server

[moiseszaragoza]

I am trying to insert into a datefield in the SQL Server
but i get this error



Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][SQL Native Client][SQL Server]Operand type clash: text is incompatible with date

/admin/news.asp, line 96

the value of my date is 9/2/2009

[yamaharuss]

Show your entire query please.

[Kuriyama]

ASP to SQL date conversion. . . .now()