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

    rajk5

      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.

       

      Thanks.