Home Forums SQL Server 2008 SQL Server Newbies Get data for the past one year (365 days) RE: Get data for the past one year (365 days)

  • August 23, 2013 at 11:17 am

    #1644505

    select ProdMonth ,ProdYear from Production

    where ProdYear >= DATEADD(yyyy,-1,getdate())

    returns no data... However , there is data present. DOn't know whats wrong...