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

Returning data based on two columns

Received Response
20
Views
1
Comments
edited Feb 18, 2020 9:19AM in Reporting and Analytics for HCM 1 comment

Summary

Data must be returned if either of the criteria satisfied

Content

HI all

Any ideas how to do the above.

I am working in Absence Calendar and have the start and end dates of the absence however the prompt must include the data if any of the dates between the start date and end date fall between the prompt dates.

e.g. the prompt dates are 01/01/20 and 31/01/20

Person 1 has an absence that started on 31/12/19 and has no end date - Included

Person 2 has an absence that started on 31/12/19 and ended on 31/12/19 - Not included

Person 3 has an absence that started on 31/01/20 and has no end date - included

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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