Modified Procedure
use Northwind
select name
from sys.objects
where type='P' and DATEDIFF(D,modify_date,GETDATE())<7
Below is the result you would see
Created Procedure
select name,create_date
from sys.objects
where type='P' and DATEDIFF(d,create_date,GETDATE())<7
Hope this small tip would be beneficial for you in your coding. Till then enjoy !!