1 Reply Latest reply on Apr 1, 2019 6:30 AM by Christian Berg

    obiee 12c Title view,need syntax for adding days to a presentation variable


      Hi Gurus,


      Please see below the scenario.


      I have a simple report with a title and table views. The report is run using a "from_date" presentation variable passed from the dashboard prompt.


      My title view should display date value which is "from_date" plus 6 days.


      For example:  if my dashboard prompt passes value of "from_date" as 4/7/2019, then my title view should show date value as 4/7/2019 plus 6 days which is 4/13/2019.


      I have used the timestampadd function as follows:  TIMESTAMPADD(SQL_TSI_DAY,6,@{from_date}).  But i see title view out put as "TIMESTAMPADD(SQL_TSI_DAY,6,@{from_date})"   instead of 4/13/2019.


      Please share any inputs.