Reg: Default values in the prompt

User_JZKI6

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,

[Deleted User]

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?

User_JZKI6

Hi Christian,

Thank you for the response.

Yes date prompt is converted string format field from datetime field.

Thanks,

[Deleted User]

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.