title: Return set of dates from hard-coded start point up to yesterday
body: <p>I'd like to return the set of dates from the 18th of June up to yesterday. My attempt was as follows but I'm getting this error:</p>
  
  <blockquote>
    <p>Executing the query ...<br>
    A calculated member cannot be used as an operand of the Range operator ( : ).<br>
    Execution complete</p>
  </blockquote>
  
  <pre><code>WITH   
      MEMBER [Date].[Date - Calendar Month].[LastDay] AS
          Tail([Date].[Date - Calendar Month].[Calendar Day].members,1)
      SET [Set_Dates] AS   
          {
          [Date].[Date - Calendar Month].[Calendar Day].&amp;[20130618]:
          [Date].[Date - Calendar Month].[LastDay]
          }  
  SELECT  
      NON EMPTY 
       [Set_Dates]  
      ON COLUMNS
  FROM [myCube] 
  </code></pre>