This discussion is archived
1 Reply Latest reply: Nov 23, 2012 8:39 AM by Hyder Mehtawala RSS

How to subtract SYSTEM CURRENT DATE and DATE pulled from Siebel

SishihoMakoto Newbie
Currently Being Moderated
Hi Experts,

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

Example:
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"


Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points