• -- Demonstrate math
    declare @date date = '2016-03-31';
    select @date CurrentDate, DATEADD(month, -1, @date) ReportDate, ReportYear = YEAR(DATEADD(month, -1, @date)), ReportMonth = Month(DATEADD(month, -1, @date));

    -- Here is a query
    SELECT s.SalesID
         , s.StoreID
         , s.[Year]
         , s.[Month]
         , s.Sales
    FROM
      dbo.Sales s
    WHERE
      s.[Year] = YEAR(DATEADD(month, -1, GETDATE()))
      AND s.[Month] = Month(DATEADD(month, -1, GETDATE()));