Help with simple report

I created a report that does the following:

Show me all of the assets that have a resource state of "Disposed"

It works great, but now I would like to be able to filter it out by the Resource Ownership History. his is where the actual date(s) of this asset are tracked.

What I would like to be a ble to do is run a report that shows me all disposed assets from a selected date, to a another selected date.

Ex. Jan. 1, 2010 to current.

Any help on this?

Below is the query code for what I have at this point.

SELECT MAX(workstation.WORKSTATIONNAME) "Workstation",MAX(workstation.MANUFACTURER) "Manufacturer",MAX(workstation.MODEL) "Model",MAX(workstation.SERVICETAG) "Service Tag",MAX(resource.SERIALNO) "Serial Number",MAX(state.DISPLAYSTATE) "Resource State" FROM SystemInfo workstation LEFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID LEFT JOIN ResourceState state ON resource.RESOURCESTATEID=state.RESOURCESTATEID WHERE (state.DISPLAYSTATE = N'Disposed' COLLATE SQL_Latin1_General_CP1_CI_AS) GROUP BY workstation.WORKSTATIONID

Thanks