How to show a full duration of travel in a report, even after the start date passes?
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?
Best Answer
-
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".
Answers
-
Are you able to provide screenshots for context?
-
Yes, on the calendar I am just focusing on the blue. @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 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.
-
I actually just figured it out with doing an OR end date is within the next 14 days. Thank you @Paul Newcome !
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!