Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calculating length of service by increment

User_DAALXNov 25 2022

Hi There,
I'm trying to calculate incremental anniversary dates using the formula below, but instead of showing 10 as the result, I really want the calculation to bring back the anniversary date i.e 10 + 25/12/2012 should bring back 25/12/2022.
CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "Employee Attributes"."Employee NHS Entry Date", CURRENT_DATE)/365.12 <10 AND (TIMESTAMPDIFF(SQL_TSI_DAY, "Employee Attributes"."Employee NHS Entry Date", CURRENT_DATE)/365.12)+2 >=10 THEN '10'
Can some one please help me with this

Added on Nov 25 2022

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

7 comments

197 views