Welcome ALL

http://www.csharp-examples.net/string-format-datetime/

SELECT     modify_date         ,type_desc         ,name     FROM sys.objects     WHERE is_ms_shipped=0         --AND modify_date>='yyyy/mm/dd'  <--optionally put in your date here     ORDER BY 1 DESC