Categories
Reg: Default values in the prompt

Hi Team,
We have date variable prompt in the format of MMM YYYY (JAN 2018), in the report level we need to show default values for last 3 months from the current month of the date prompt.
We don’t have access to RPD for creating variables can someone suggest on this scenario.
Thanks,
Comments
-
First question: Your "date variable prompt" gives you an acutal date as an output which is simply formatted MMM YYYY? Or is that a string?
0 -
Hi Christian,
Thank you for the response.
Yes date prompt is converted string format field from datetime field.
Thanks,
0 -
There's not much you can do with a string that doesn't require extreme amounts of conversion and hence will costs performance.
If you work with proper dates and / or properly formed date dimensions then things become a lot easier.
0