Using Presentation Variables for Date Comparison???
I'm trying to create a report that will allow users to select two date ranges from a dashboard prompt. (Example: Revenue totals from 1/1/2010 - 5/1/2010 vs. Revenue from 1/1/2011 - 5/1/2011). In CRM there is a Current Date and Previous Date field on the Oppty - the values are identical. In the report the Current and Previous Date columns are displayed and in the FX box for these columns I'm trying to create a statement with a Presentation Varible, so when users select the needed date ranges the values are passed into the report. The only way I've been able to get the Presentation Varible to work in the FX box is by using some sort of "CAST as Character" statement like: FILTER("- Revenue Custom Metrics".S_CUR_5 USING CAST("- Opportunity Custom Attributes".DATE_27 AS CHARACTER) >=