Author Topic: Issue date prompt  (Read 518 times)

Offline msm

  • Full Member
  • ***
  • Posts: 5
  • Forum Citizenship: +0/-0
Issue date prompt
« on: 25 Aug 2009 01:23:08 pm »
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!