1 Reply Latest reply on Nov 23, 2012 4:39 PM by Hyder Mehtawala

    How to subtract SYSTEM CURRENT DATE and DATE pulled from Siebel

      Hi Experts,

      How do I subtract the CURRENT DATE and Date that is entered in Siebel?

      CURRENT DATE - Date record in Siebel

      Current Date = 11/25/2012
      Date record in Siebel = 11/20/2012

      Technically the answers I want will be 5.
      How do I do this? My idea is to put an expression in the BMM layer but I just want to get as well your ideas:

      Current_Date - "Oracle Data Warehouse"."Catalog"."dbo"."TABLE_NAME"."COLUMN_NAME"