Issue date prompt

[msm]

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!