For viewing the modified date of Stored Procs and UDF alone:
Routine_name, Routine_Type, Created, Last_altered
Routine_type in ('PROCEDURE', 'FUNCTION')
Last_altered desc, Routine_type, Routine_name
For viewing the modified date of Stored Procs, UDF and Views:
We can query 'Sys.Objects' table and find out the list of Stored procs, UDFs, Views etc., which have got modified.
[name] as 'Object Name',
[type] as 'Object Type',
Where [type] in ('P', 'FN', 'TF', 'V')
Order by Modify_Date desc, [type], [name]
The above query will list all 'SPs', 'UDFs' and 'Views' in the current database with its 'Created date' and 'Modified date'. We can further finetune this code to match our exact need!
Check out create_date and modify_date columns in sys.triggers.
select * from sys.triggers