Home Forums SQL Server 2008 T-SQL (SS2K8) Calculate 90 days and 3 Years agon from an Effective Date in a table? RE: Calculate 90 days and 3 Years agon from an Effective Date in a table?

  • September 30, 2014 at 12:36 pm

    #1749245

    Use LinksUp code, just add the from clause that you supplied in your OP

    select EffectiveDate, DATEADD(dd, -90, DATEADD(yy, -1, EffectiveDate))

    from FL.CEFHistory

    Executive Junior Cowboy Developer, Esq.[/url]