nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

Francesco Milazzo

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

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

Find more posts tagged with

Filters

Accepted answers

All comments

Hassan El Bouihi-Oracle

Hello Francesco,

You may want to try something like:

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

Thank you

Hassan