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!

TIMESTAMPDIFF function in OBIEE Answers

sivausinJun 15 2010 — edited Jun 15 2010

Hi experts,

I have a Answers report, where I have included a column and changing the fx formula to find out the time diff ..

TIMESTAMPDIFF(SQL_TSI_DAY, "Bank Transactions - Payor Aging".AccountingDate, "Bank Transactions - Payor Aging".AccountingDate)

here I want the second "Bank Transactions - Payor Aging".AccountingDate to be replaces with any date like as below

TIMESTAMPDIFF(SQL_TSI_DAY, "Bank Transactions - Payor Aging".AccountingDate, '06/02/2010') for June-02-2010.

But, the above date format is working... can any suggest what format I have give here to work.

Thanks in Advance
S

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2010

Added on Jun 15 2010

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

4 comments

8,665 views