I’m a newbie to Web Intelligence 3.x.
I was wondering if its possible to format an object (date) with a time stamp to without time stamp in the query filter.
jbakerstull (BOB member since 2012-01-25)
I’m a newbie to Web Intelligence 3.x.
I was wondering if its possible to format an object (date) with a time stamp to without time stamp in the query filter.
jbakerstull (BOB member since 2012-01-25)
Welcome to B:bob:B!
It might be possible. 8) But I need to understand your requirement first.
You have a query filter, based on a dimension object, such as:
[Date] Greater than 1/25/2012 12:00:00 AM
And you want to remove the time portion of that the date. Is that correct?
MichaelWelter (BOB member since 2002-08-08)
There were a few discussions in the forum around that topic. Here’s one. The short answer is yes, it can be done, but be aware of the consequences. I have a WebI report that lets the user select a particular status report for a project by first choosing a project ID, then selecting the date submitted (cascading prompts). The user didn’t want to see the time portion of the datetime object. I used
to_char(table.column, 'MM/DD/YYYY')
as type character, and the LOV displays without the time.
charlie (BOB member since 2002-08-20)