General OBIEE

Get Involved. Join the Conversation.

Topic

    Giuseppe Botta
    Calculate Yesterday date based on CURRENT_DATE variable
    Topic posted July 5, 2017 by Giuseppe BottaSilver Medal: 2,000+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, Compensation, OTBI, Report Output, Reports, SQL 
    1593 Views, 2 Comments
    Title:
    Calculate Yesterday date based on CURRENT_DATE variable
    Summary:
    Calculate Yesterday date based on CURRENT_DATE variable
    Content:

    Hello,

    how do I could calcolate obtain yesterday date based on current_date field in an OTBI analysis, to use it in a where clause for example?

    ex "...WHERE "Compensation Person Worksheet Details"."Worksheet Last Update Date" < CURRENT_DATE-1" (not working)

     

    Thank you in advance

    Comment