title: ColdFusion Report Builder passing {ts yyyy-mm-dd 00:00:00} date into sub report
body: <p>Quick question. I've been googling but have yet to find an answer to this problem. I am creating a sub report inside CF Report Builder. The problem I am having is I have to pass a date into my query in the sub report, and the date is coming in as an invalid format.</p>
  
  <p>My query for the main report gives a month end as a date, here's the code that creates the date:</p>
  
  <pre><code>TO_DATE('09/30/2018','MM/DD/YYYY')
  </code></pre>
  
  <p>But when that gets passed to the sub report/sub query, it comes in as this:</p>
  
  <pre><code>{ts '2018-09-30 00:00:00'}
  </code></pre>
  
  <p>... even though the actual query just returns '09/30/2018'. I know its just the way the report builder is formatting the date, but how can I get it to pass in as 9/30/2018 so it won't error out in my subquery? </p>