• 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 would have figured it out just using one dateadd and one datediff