How to show a full duration of travel in a report, even after the start date passes?

Alicia D

Hello, I am having the issue when a report calendar for time off in the next 2 weeks. It only lets me choose, start date in the next 14 days or end date in the next 14 days. The issue with that is, even if someone is traveling that whole week, it clears from the report once it passes the start date. How can I fix this?

Paul Newcome

Within the report filter you can click on the "AND" to change it to an "OR". You can also create separate filter groups so that it is (for example) "A or B" and "C or D" or more likely "A and B" or "C and D".

Paul Newcome

Are you able to provide screenshots for context?

Alicia D

Yes, on the calendar I am just focusing on the blue. @Paul Newcome

Screen Shot 2024-02-13 at 1.53.57 PM.png

Screen Shot 2024-02-13 at 1.54.05 PM.png

Screen Shot 2024-02-13 at 1.55.00 PM.png

Paul Newcome

Within the report filter you can click on the "AND" to change it to an "OR". You can also create separate filter groups so that it is (for example) "A or B" and "C or D" or more likely "A and B" or "C and D".

Alicia D

@Paul Newcome okay this is helpful to know, thank you! I am still struggling to figure out what I should put in the filter to have it show upcoming travel as what is starting in the next 14 days, as well as, any duration that is currently happening during that time.

Alicia D

I actually just figured it out with doing an OR end date is within the next 14 days. Thank you @Paul Newcome !

Paul Newcome

Happy to help. 👍️