Problems with dates

[NiteCrawlr]

Hi,
I'm having problems in this line:

Select * from ngrm10 where pcc_grm = '&quot;&pcc&&quot;' and dte_grm >= '&data_ini&' and dte_grm <= '&data_fim&'&quot;

Can I do this?? Is this right??
this is the error:

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

[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string.

/rayan/resultado.asp, line 66

Obs: dte_grm has datetime properties (SQL Server 7)

Thanks

Frederico

 

[vasah20]

It seems like your &quot;&quot; marks are off
try this

Select * from ngrm10 where pcc_grm = '&quot;&pcc&&quot;' and dte_grm >= '&quot;&data_ini&&quot;' and dte_grm <= '&quot;&data_fim&&quot;'&quot;

hopefully that does it for you.
leo