Feeding a Parameter into an ADO SQL script

[rier]

Can anyone help?

I have an ADO connection and the beginning of the SQL is as follows...


declare @fromdate as datetime
declare @todate as datetime
set @fromdate = 'Jan 01 2002 00:00:00AM'
set @todate = 'Jan 30 2002 00:00:00AM'
SELECT
count(*) as groupcount, CustomerGroup.ID, CustomerGroup.GroupName, CustomerGroup.T........., etc


What I want to do is to set up a range parameter which will set the @fromdate and @todate.

Does anyone know how I would approach this prob?

Thanks

Richard