Oracle Transactional Business Intelligence

Products Banner

Calculate Yesterday date based on CURRENT_DATE variable

215
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