title: How to set a default parameter date for the beginning of the month to yesterday date
body: <p>I have build an SSRS report. I set a default date parameters as following:
  startdate : take the first day of the month.
  EndDate  : take yesterday date.</p>
  
  <p>This code for the beginning of the month 
  <code>=DateSerial(Year(Now()), Month(Now()), "1").AddMonths(0)</code>
  This code for yesterdate date</p>
  
  <p><code>=DateAdd(DateInterval.Day,-1,CDate(FormatDateTime(Now,DateFormat.ShortDate)))</code></p>
  
  <p>The date works perfectly until, a new month comes, the result will be like this:
  startdate: 01. 5 2019
  end date: 30. 4 2019</p>
  
  <p>where it should be :
  startdate: 01. 4 2019
  end date: 30. 4 2019</p>
  
  <p>how can i make sure if a new date comes , it will take the first day of the previous month.</p>