Hi,
my report is build on a cube. I have an issue with the date prompt.
What i already tried is the _make_timestamp([date] ) >= ?startdate?. The error is 'sqlPrepareWithOptions' status='-239'.
Added 2 filters, but the result is empty. There is data available for the selection.
[date] >= ?startdate?
[date] >= ?enddate?
cast doesn't work. The format of the date in the cube is 2009/05/18.
What function is the right one?
Thanks!