declare @tbl table(date datetime);
insert into @tbl values ('20110101');
insert into @tbl values ('20110703');

-- do a test to see if there are dates that won't convert.
select * from @tbl where day(date) > 12 and date > current_timestamp;

-- compose the date string in the YYYYMMDD format and update 
-- This format will be interpreted correctly in any DATEFORMAT
-- setting. But convert it using style 112 anyway.
update @tbl set date= 
   convert(
      datetime
      ,cast(year(date) as varchar(4)) +
         right('0'+cast(day(date) as varchar(2)),2) +
         right('0'+cast(month(date) as varchar(2)),2)
      ,112)
where
   date > current_timestamp
   and day(date) <= 12;

select * from @tbl

quote:

---

Originally posted by Steve2106


Is there a way I could extract all the offending records into a new table, repair the dates then update them in the original table?

---

select * into YourBackupTable from YourTable

select * into YourBackupTable from YourTable where
   date > current_timestamp
   and day(date) <= 12;

update YourTable set DateCreated = 
-- select
   convert(
      datetime
      ,cast(year(DateCreated) as varchar(4)) +
         right('0'+cast(day(DateCreated) as varchar(2)),2) +
         right('0'+cast(month(DateCreated) as varchar(2)),2)
      ,112)
-- ,* from YourTable
where
   DateCreated > current_timestamp
   and day(DateCreated) <= 12;