[~countrdd] To find rates, adjust the interval at which you consider them deleted by carrier then run this

select * from `outbound_routes` 
where `last_modified_date` < date_sub(now(), interval 180 day)
order by `last_modified_date` ASC

To delete them, change the

 select *

to

 like this

sql
delete from outbound_routes
where last_modified_date < date_sub(now(), interval 180 day)

`

[~countrdd] , Thanks for your suggestion, We will implement it in our next version.

here already search by from date and to date filter exists. so after discuss add modified date filter in feature.

Note : No Change Required.

Hello Kanu Patel,
there are no any search option for from date-To date in Origination and Termination rate in community v6.0 source, and per requested by user for search option with from date and date as per created/modify date. so we need to implement this features.