title: specific date within select expert
body: <p>My report is scheduled to automatically run on a custom calender which is: 
  1st of the month to the 7th 
  8st of the month to the 14th
  15th of the month to the 22nd
  23rd of the month to the last day of the month</p>
  
  <p>What i am trying to do basically is when the report is run, select the dates between current day -7 to current day -1 unless its the last day of the month and then i want it to run it from the 22nd of the last month to the last day of the last month. i hope this makes sense.
  Thanks
  Houlahan</p>