List of values as Calendar for "Date of Completion"

[Former Member]

Hello Friends , Please help fix this format for a field "Date of Completion" which is coming from BI cube now when I put that in webi report as user prompt it does not prompt for Calendar instead it gives the values like 100's of dates 10/11/2008, 01/1/2008 .....

User does not like it and they want to see a calendar on right of the prompt so that When they click calendar they can select the date they want.

I checked in BI Cube for "Date of Completion" master data it is referred to 0date as standard field so now what else i should do to maintain the list of values as "Calendar" in universe

Thanks

Soniya

[Former Member · Accepted solution]

Hi,

Did you check that your universe object referring "Date of Completion" has Date data type?

Can you also provide the BOE verson you are using?

I remembered that the calendars were not displayed in XIR2 version.

Didier