title: Date query in SSRS
body: <p>I currently use the expressions:</p>
  
  <pre><code>=today.adddays(1-today.day)
  
  =Today.AddDays(1-Today.Day).AddMonths(1).AddSeconds(-1)
  </code></pre>
  
  <p>to get the first and last day of the current month (last day I need to include seconds).</p>
  
  <p>Is there a way of tweaking these expressions to bring through the first day and the last day (inc seconds) of the previous month? </p>
  
  <p>So for example the required output for expression 1 would be:</p>
  
  <pre><code>01/11/2017
  </code></pre>
  
  <p>For expression2 it would be:</p>
  
  <pre><code>30/11/2017 23:59:59
  </code></pre>
  
  <p>Any advice gratefully accepted.</p>
  
  <p>Thanks</p>