I have a report which shows all employees holiday applications. These forms have a “From” and “To” date of their holidays.
Trying to apply a date range filter with a start date and end date. Got it to work basically where there is an “exact” match, ie From/To dates match Start/End dates. The trick I need to achieve is to show on the filtered report all employees who have AT LEAST ONE DAY of their holiday period falling in the Start/End filter dates. Just can’t get my head round the logic involved.