Hi,
I have Week Ending Date prompt in my report where I display all the Saturday dates .
When the report is refreshed, in the prompt screen the week data shows the timestamp as below.
12/10/2011 12:00:00 AM
12/3/2011 12:00:00 AM
11/26/2011 12:00:00 AM
11/19/2011 12:00:00 AM
.
.
.
But in the universe, the same LOV does not show any timestamp, only the date is displayed. I tried using Cast(WEEK.WK_DESC as Date) in the universe but still in the WebI the timestamp is coming.
Also in TD, this week column is defined as Date data type only.
Can any one please help why this timestamp is coming in the WebI prompt screen and how to remove it?
Thanks in advance.