MFA Icon

MFA for Oracle Community

Starting September 2025, Oracle Community will require Multi-Factor Authentication (MFA) for all member logins. This simple extra step helps protect your account—and the community data—by adding an additional layer of security during sign-in.

Read more about MFA

Oracle Transactional Business Intelligence

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

Calculate Yesterday date based on CURRENT_DATE variable

311
Views
2
Comments

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

Comments

Welcome!

It looks like you're new here. Sign in or register to get started.