Thanks Michael,

That did the trick. I edited your code to:

select dateadd(dd,(datediff(dd,'1/1/2010',dateadd(dd,13,

dateadd(qq,datediff(qq,'1/1/2010',getdate()),'1/1/2010')))/14)*14,'1/1/2010')

and that worked perfectly. I don't think that I...

Thanks, but that doesn't really help me at all. I think that I would have to combine two of the functions that are listed in the link.

After you change the data type using the script and if you're still getting the error try to change the error output of the column to ignore truncation errors.