Timestamp Diff and then Timeadd
Hi I am using OBIEE 11g I would like to know how to take a timestampdiff between a date measure and a numeric number then apply that value and add it to a date measure to get the date.
Example:
TIMESTAMPDIFF(SQL_TSI_DAY,100, "Pending Claim - Process Time"."Claim Date") ----// NOTE: I get an error here about incompatible Data types
OUTPUT is *5*
I want to take that output of five and then apply it to the current_date so I get the end result of the date that item will be 100 days
Final out put 14-Mar-2013
Here is what i have so far that does not work:
TIMESTAMPDIFF(SQL_TSI_DAY,100, "Pending Claim - Process Time"."Claim Date")
+
CURRENT_DATE