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

Formula for NOT Current Year ("Worker"."Employee Hire Date")

Summary:

OTBI report - Filtering on YEAR for field name "Worker"."Employee Hire Date"

Content (required):

I have an OTBI report where the data returned should be for employees NOT hired in the current year. For example, today if the report runs, it should only return data for employees with a hire date less than (before) the current year 2023. In Feb 2024 when the report runs it should only return data for hire dates not in 2024; in other words, before 2024.

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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