I am using BO XI R2 , DB2 v8.0.
I have created the following simple condional object in designer.
@Select(Table1\TimePeriod) BETWEEN
Date(@Prompt('Enter the From Date (MM/DD/YYYY)','D',,mono,free))
AND
Date(@Prompt('Enter the To Date (MM/DD/YYYY)','D',,mono,free))
TimePeriod - is in 'mm/dd/yyyy' format.
In WebI Report panel , This prompt is showing the calendar to pick up the date.
After selecting the date, In the text box the date is showing along with time. [ Ex: 2/11/2008 12:00:00 AM ].
Is it possible to truncate the time part and to show only date in the prompt text box. The user is getting confusion , if it is showing like 12:00:00 AM.
Please give me a suggestion or any alternative method to achive this.
Thanks for giving the reference.
It's really useful to me.
But unfotunately I am not able to get the solution for my issue.
I am not talking about the LOV issue. As they said we can convert the date-time object to date by using the function.
In the prompt I have not used any LOV object, I left the LOV parameter as blank.
Here, the user can type the date or else they can pick up the date from calendar.
After picking up , It's showing date with time but I need to show date only.
Please correct me , if I am wrong.
Unfortunately, that’s the way the calendar works. You can remove the time (and the calendar) by converting your object to a character string, which is why I linked you to the FAQ.
You can tweak the javascript file used to build the calendar control but it is at best a hack though I’ve done it in our development environment. The issue for me was the calendar control behaviour would have been different between Crystal and Webi and didn’t promote a consistent look and feel for our users.
We are using XIr2 SP2 and the file I altered was located here: …\enterprise115\desktoplaunch\viewers\cdz_adv\lib\calendar.js
Again, this was a hack job just to see if I could do it and it hasn’t moved beyond development (no real testing). That said, to make this change, I simply commented out lines 241-256.