simple query not so simple

SQL= select count(*),sum(atp_amount) from fdsmastrep where trans_month = 10/1/2004

the trans_month field is a date field and I need to get the records for the year beginning 10/1/2004 and ending 9/30/2005

I get an "inconsistent data types" error.

can somebody help me out? Received on Mon Oct 10 2005 - 00:42:51 CDT