Skip to content

Oracle Communities

Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Calculate Yesterday date based on CURRENT_DATE variable

279

Views

2

Comments

Giuseppe 1234

Giuseppe 1234 Rank 2 - Community Beginner

July 2017 in Oracle Transactional Business Intelligence

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

Tagged:

0

Comments

Clifford-Barrington Trett Rank 2 - Community Beginner

July 2017

maybe use: TIMESTAMPADD(SQL_TSI_Day , -1, current_date)

0
RichardChan Rank 6 - Analytics Lead

July 2017

What message are you getting with CURRENT_DATE - 1 ? and yes TIMESTAMPADD is your other option

0