presentation variable changing the data type of date to string from Calende
YogeshOct 14 2009 — edited Oct 15 2009Hi Gurus,
I am having a strange issue.I have a Start date and end date prompt which are not on any presentation column e.g (case when 1=0 DATE.DATE else cast('2100-12-31 as DATE')end).
Now from this prompt i set 2 presentation variable startdate and enddate to use in my sql filter in the report.i use these variable to calculate end date for these 2 dates and then i apply the between function with these 2 dates.
The issue is when the dashboard runs for the first time the presentation variable takes the dates as DATE '2009/14/10' and when i change the dates and click on go button, the variables takes '10/15/2009' as string anf hence the DATE functions in my SQL filter fails and throughts VD errors.
Any suggestions!!!!!