(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
Hello All!
More help needed......
I'm trying to create a filter that I can use daily to do a vertical slice of just the activities that are happening on a specific day.
Here's what I have so far but I'm not sure what I'm missing:
Activity Status not equal to Completed
Start equals Dec 1
Finish is great than or equal to Dec 1
Printer-friendly version
Send to friend
glad I could help
Excellent! Thanks - I got it to work!
you did not say if Dec 1 was the data date or a date in the future so
filter
where
Activity status is not equal to complete
or
Start is less than or equal to Dec 1
or
Finish equals Dec 1
Heather, that wont capture activities that have started before 1st December and are currently in progress.
There are four scenarios that can happen on that day:
Your filters will need to be (OR) for all the above scenarios.
Email: PPadmin@planningplanet.com
Replies