Hello All,
I need to change the paramdisplayvalue('date') of a from and to date in a date prompt to display long name of month.
I tried using string2date(paramvalue('date')). This works . But if if nothing is selected then it will display --,since there is no value to format.
Also tried Cast and to char on paramdisplayvalue() which gives a parsing error.DB:ORACLE
Hi
You should be able to change the style of the date without modifying the actual layout calculation. If you choose something like Date Style = Long and Display Months = Long name you should end up with something like "27 October 2016".
Dax
Do you get your date from a date dimension in your datawarehouse?
Have you consider having a couple of blocks (I'm assuming you're putting these values into the header of a report or similar)? You could then render then two blocks based on a variable of ParamDisplayValue('date') is not missing.