Calculate Yesterday date based on CURRENT_DATE variable

Giuseppe 1234

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

Clifford-Barrington Trett

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

RichardChan

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