Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Truncate Date

528559Nov 5 2008 — edited Nov 6 2008

Hi,

How Do I truncate a date in Answers, like in Oracle we use Trunc(mydate). I only want the date part.

I have a filter which goes something like this:

RECEIVED DATE is between TimestampAdd(SQL_TSI_MONTH, -15, CURRENT_DATE) and CURRENT_DATE.

If I have a record with Received Date =11/05/2008 and the current_date is 11/05/2008, BI does not take into account the current_date record. That's Why I need to be able to truncate the RECEIVED DATE.

Thanks
rkingmdu

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 4 2008

Added on Nov 5 2008

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #date

6 comments

472 views