title: SQL Server Reports Builder - showing dates of current week (help)
body: <p>I am using SQL Server Report Builder to generate a weekly report to show the weekdays Monday - Friday and then the relevant dates.</p>
  
  <p>The report pulls the information from a calendar in SharePoint 2016.</p>
  
  <p>Instead I have created 5 columns with static weekdays and the week dates:</p>
  
  <p>The following generates the weekdays:</p>
  
  <pre><code>=IIf(UCase(Format(Fields!Start_Time.Value, "dddd"))="MONDAY",FORMAT(Fields!Start_Time.Value, "h:mm tt ") &amp; FORMAT(Fields!End_Time.Value, "- h:mmtt"),"")
  </code></pre>
  
  <p>The following generates the week dates:</p>
  
  <pre><code>=FORMAT(Today.addDays(1-weekday(Today,FirstdayOfWeek.Monday)),"dd/MM/yyyy")
  </code></pre>
  
  <p><p>
  <a href="https://i.stack.imgur.com/Ecflj.jpg" rel="nofollow noreferrer">Screenshot of the SQL Report</a>
  <p>Which means show the date/time of each weekDay otherwise leave blank.<br/>
  The problem with this approach is that does show all the entries even those of last week ... </p>
  
  <p>The purpose is to show only for current week.<br/>
  Unfortunately, I am out of ideas and not sure what else can be done?</p>