title: How to get date as Header in SQL Server 2005
body: <p>I am trying to get dates as headers that change depending on the current date. Here is an example of what I am trying to do in SQL Server 2005.<br>
      select c.[ar cust edi sef type],
          SUM(case when<br>
              s.[ar sale date] like DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))-7  and s.[ar sale document type] like 'invoice'
              then s.[AR SALE Balance Due]
              else 0 end) as getdate(),    </p>
  
  <p>getdate() does not work.  Is there a way I can return a date as the header?</p>