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

How to filter population with a seniority date less than 365 from today in OTBI

Received Response

21

Views

1

Comments

Francesco Milazzo Rank 1 - Community Starter

Aug 5, 2024 8:58AM edited Aug 5, 2024 9:23AM in Oracle Transactional Business Intelligence

I tried to convert the enterprise seniority date filter in SQL and insert:

"Worker"."Enterprise Seniority Date" >= (SYSDATE -365)

Tagged:

• Filters

0

Answers

• 

  Hassan El Bouihi-Oracle Rank 6 - Analytics Lead

  Aug 5, 2024 3:07PM

  Hello Francesco,

  You may want to try something like:

  "Worker"."Enterprise Seniority Date"  is greater than  CURRENT_DATE - 365

  Thank you

  Hassan

  0