title: Filtering by same day for current Month in Tableau
body: <p>Not sure if I am missing something on how to do this but if you wanted to filter your data on say the 12th Day of each Month, how is that achieved? I want it so that whenever it is viewed it will show the data for the 12th of the current Month. </p>
  
  <p>I've tried parameter but you can only pick a date, which will not be dynamic. </p>
  
  <p>I used as below in dataset:</p>
  
  <p>dateadd('day',11,datetrunc('month',today()))</p>
  
  <p>When I apply this to filter in sheet, it crashes the workbook.</p>
  
  <p>I'm thinking how you can do this as in Excel, you can pick the day of the Month you want and it fixes it to the current Month, can tableau not do that?</p>
  
  <p>I can't pick anything dynamic in the relative date range, again like 12th of "Current Month", only fixed manual dates.</p>
  
  <p>Any pointers would be really appreciated.</p>
  
  <p>Thanks</p>
  
  <p>Andrew</p>