Were you able to resolve your issue.
I am facing similar issues in of my reports
Check your settings for timezones ... also post the WHERE clause of the query, I'll take a look at that too.
SQL is exactly the same
Below are sql , for first i am getting values whereas for second no data
Saw the SQL from advanced tab in analysis
(cast("Start Date"."Start Date" as date) = date '2006-08-01')
(cast("Start Date"."Start Date"as date) = date '2009-05-15')
One thing which i observed now, i tried to create a prompt for the object and in that i didn't get an option for calendar?? any idea why?
Please post physical SQL that get's sent back to the database ... I'm wondering if you have data type issues ... why logically casting the start date?