Below query gives you the list of stored procedures which has been CREATED in last 7
SELECT name, create_date Note
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 7
: You can change the 7
number in the WHERE condition with N
-- here N represents the number of days