Asset Disposed Report

I am trying to create a report that will run every month, and it will list assets that we have disposed during that month. I'd like it to use the date that we actually switched the assets "Resourse State" to "Disposed" as the criteria in the date filter. Right now it only gives me the following options in the Date Filter - “Expiry Date” “Acquisition Date” “Lease Start” and “Lease End”.

Here is the query for the report using "Expiry Date" as the date filter (we don't want to use Expiry because we could very well keep using an asset past the expiry date)

SELECT product.COMPONENTNAME "Product",productType.COMPONENTTYPENAME "Product Type",resource.RESOURCENAME "Resource Name",resource.ASSETTAG "Asset Tag",state.DISPLAYSTATE "Resource State" FROM Resources resource LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID LEFT JOIN ComponentType productType ON product.COMPONENTTYPEID=productType.COMPONENTTYPEID LEFT JOIN ResourceState state ON resource.RESOURCESTATEID=state.RESOURCESTATEID WHERE ((state.DISPLAYSTATE = N'Disposed' COLLATE SQL_Latin1_General_CP1_CI_AS) AND (((resource.EXPIRYDATE >= <from_thismonth>) AND ((resource.EXPIRYDATE != 0) AND (resource.EXPIRYDATE IS NOT NULL))) AND ((resource.EXPIRYDATE <= <to_thismonth>) AND (((resource.EXPIRYDATE != 0) AND (resource.EXPIRYDATE IS NOT NULL)) AND (resource.EXPIRYDATE != -1)))))

Could someone let me know if what I'm asking for is possible, and how to do that? Thanks!