;with data as 
(
 select 'klsjadlkj  ads891 3y1kjnd al k 22/31/2012 lk;adk asl;k das#' as things
 union all
 select 'k 11/1/2012 dk asl;k das#' as things
 union all
 select 'al k 10/07/2012' as things
 union all
 select '12/31/2012' as things
 union all
 select 'klsjadlkj sadas ads891 3y1kjnd al k 12/31/2012 lk;adk asl;k das#' as things
), dates as
(
 select things,SUBSTRING(things,patindex('%[01][0-9]/[0-3][0-9]/[0-9][0-9][0-9][0-9]%',things),10) as found_date
 from data
 where things like '%[01][0-9]/[0-3][0-9]/[0-9][0-9][0-9][0-9]%'
)
select things,found_date
from dates
where found_date = CONVERT(CHAR(10),dateadd(day,-8,getdate()),101)