I am using WEBI 3.1 /sql server database
The report has date parameters in Query filters (objects from universe) and its showing timestamp in the prompt window and I am trying to remove the time stamp by appending convert function to this object in universe level (see below)
CONVERT(DATE,FROMDATE) and tried CONVERT(varchar, FROMDATE)
But the parameter is still showing time stamp
How to trim the time stamp?
Cristina (BOB member since 2009-02-27)
Please do bit of search on forum , below is one example
bob2210 (BOB member since 2010-09-23)
I see many work around for Oracle
but nothing in SQL server, this is iam trying
CAST(TableA.Column AS DATE)
I want this in sql server
to_date(@Prompt(‘Date?’,‘A’,‘Class\Object’,mono,free),‘MM/DD/YYYY’)
Cristina (BOB member since 2009-02-27)
You need to modify object LOV in universe by using custom sql
bob2210 (BOB member since 2010-09-23)
CONVERT(DATE,FROMDATE) has been used for the object to trim the timestamp in universe level. It is working in webI rich client and even when you click Display in Edit properties of the object in universe level. However, when opened from Info view it is still showing the time stamp
Cristina (BOB member since 2009-02-27)