You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

The filter should show just the Years: 2021 2022 2023 2024

in Reporting and Analytics for HCM

Hi,
this is about the excel format ,When the user clicks on the filter for Date of Joining or Last Working Day, instead of seeing individual dates like:30-Jan-2023 08-Feb-2023 10-Feb-2022 The filter should show just the Years:2021 2022 2023 2024 . date display format is correct but client want modification in filter condition and i am attaching screenshots of what we are extracting now and how client wants to be . image : 1 is present one and expectation would be image 2 and i am attaching the sql qhich i am using right now
TO_CHAR(ppos.date_start, 'DD-Mon-YYYY', 'NLS_DATE_LANGUAGE=ENGLISH') AS start_date,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!