4 Replies Latest reply: Jun 15, 2010 9:40 AM by MadanThota RSS

    TIMESTAMPDIFF  function in OBIEE Answers

    sivausin
      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