Tips on using this forum..

(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.

One Day Filter

4 replies [Last post]
Heather Hadley
User offline. Last seen 1 day 21 hours ago. Offline
Joined: 29 Jan 2019
Posts: 23
Groups: None

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 

Replies

Zoltan Palffy
User offline. Last seen 2 days 4 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2810
Groups: None

glad I could help 

Heather Hadley
User offline. Last seen 1 day 21 hours ago. Offline
Joined: 29 Jan 2019
Posts: 23
Groups: None

Excellent!  Thanks - I got it to work!

Zoltan Palffy
User offline. Last seen 2 days 4 hours ago. Offline
Joined: 13 Jul 2009
Posts: 2810
Groups: None

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

 

Santosh Bhat
User offline. Last seen 5 hours 43 min ago. Offline
Joined: 15 Apr 2005
Posts: 296

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:

  • 1: Started before 1-Dec and will finish after 1-Dec. ie. in progress
  • 2: Started before 1-Dec, but will finish on 1-Dec
  • 3: Starts on 1-Dec and will finish after 1-Dec
  • 4: Starts and Finishes on 1-Dec

Your filters will need to be (OR) for all the above scenarios.