Hi Gurus,
Is there any way to remove day number ( 1,2...31) from the Date prompt from the display.
We are using date prompt in the listbox.
Thanks in Advance,
Joys
Do you want to extract the day number from the date chosen, or do you want to only prompt for month and year?
Yeah want to see only month and year in prompt.
Using value prompt we achieved it but is there any way using 'date prompt'.
As Cognos don't allow to edit data properties for date prompt.
Playing a little with the styles you may achieve that
For example with the following code placed it in a html item
<style>
.pd
{
visibility:hidden;
;
}
.pds
{
visibility:hidden;
}
.pw
{
visibility:hidden;
}
</style>
I have achieved the days not to be visible.
With the above you should take into consideration that the value of the prompt will be the current day + month and the year the uses has selected.
So you will have to manipulate the DateParameter in your query
It's working offcourse but day number is again appearning in the edit box. We are not using calendar box
When we want month/year-only selections for date ranges, we will sometimes use value prompt dropdowns with display values like "September 2012", "August 2012", "July 2012", etc. and use values appropriate to what is needed for a parameter or filter. We typically back them with a query that determines the valid date ranges to present based on what's in the database/cube.
Not necessarily slick looking, but it does the job for us.