BusinessObjects Board

Removing Time Stamp from date prompt

building reports webintelligence legacy
#1

Hi ,

I have two prompts one is Start date and second one is End Date,
These two prompts have lov’s, i have to select values .These have the format like “5/4/09 HH:MM AM”.
These two values are appearing on the report by using variable userresonse.
When i am getting the values in report it has the format like “5/4/09 HH:MM AM” .
In my report i want to make this as ‘5/4/09’,means i have to remove the time stamp at report level and lov’s.

Please can any one guide?

Thanks & Regards,
Ramnaresh.P.

ramnaresh (BOB member since 2009-03-18)

#2

To do at report level, check https://bobj-board.org/t/129280

To do at universe level, it is important on which db you are in. Still, if Oracle, see https://bobj-board.org/t/17156

Jansi :india: (BOB member since 2008-05-12)

#3

when we enter the date in view mode it takes timestamp…when we convert enter date using todate() and format it using formatdate(), there will be issuw when user enter the date in format… MM/dd/yyyy.
solution is as below:


=If(IsError(FormatDate(ToDate(UserResponse ([Query 1] ; "Enter Effective Date of the Report"); “MM/dd/yyyy h:mm:ss a");"MM/dd/yyyy"));FormatDate(ToDate(UserResponse ([Query 1 ] ; "Enter Effective Date of the Report");"MM/dd/yyyy");"MM/dd/yyyy");FormatDate(ToDate(UserResponse ([Query 1 ] ; "Enter Effective Date of the Report");"MM/dd/yyyy h:mm:ss a");"MM/dd/yyyy"))


it handles both date format...

Satyaa :india: (BOB member since 2008-04-02)