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.
My query for the main report gives a month end as a date, here's the code that creates the date:
TO_DATE('09/30/2018','MM/DD/YYYY')
But when that gets passed to the sub report/sub query, it comes in as this:
{ts '2018-09-30 00:00:00'}
... 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?