General OBIEE

Get Involved. Join the Conversation.

Topic

    Kate Burk
    RelativeDate function in OBI?Answered
    Topic posted October 14, 2015 by Kate BurkRed Ribbon: 250+ Points, tagged Customizing Reports, OBI Answers, Reports 
    119 Views, 2 Comments
    Title:
    RelativeDate function in OBI?
    Content:

    In BO, one of our reports calculates a date by adding 90 days to the start date using the RelativeDate function.

    Candidate Start Date + RelativeDate(90)

    I am having trouble seeing what is available in OBI to calculate this specific date value.

    Has anybody come across this issue or know of the formula?

    Best Comment

    Caroline Gladwin

    Look at the timestampadd function - this allows you to add any number of any unit of time to a date. 

    eg timestampadd(SQL_TSI_DAY, 90, candidate start date)

    Change DAY to MONTH, YEAR etc for different units

    Change positive number to a negative to go back in time

    Thanks Caroline

    Comment

     

    • Caroline Gladwin

      Look at the timestampadd function - this allows you to add any number of any unit of time to a date. 

      eg timestampadd(SQL_TSI_DAY, 90, candidate start date)

      Change DAY to MONTH, YEAR etc for different units

      Change positive number to a negative to go back in time

      Thanks Caroline

      • Kate Burk

        Thanks! I had some trouble figuring out how to use Offer Actual Start Date as the date but figured out you needed to use CAST AS TIMESTAMP to make it work.