Skip to content
ProjectControls.com
Oracle Primavera - PM6

One Day Filter

In the Open Standard
hhadleyMember for 7 years 8 months
Created
4
3
0

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 

Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Santosh Bhat ·
    #1

    Heather, that wont capture

    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.

    Report
  2. 0
    Zoltan Palffy ·
    #2

    you did not say if Dec 1 was

    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

     

    Report
  3. 0
    hhadley ·
    #3

    Excellent!  Thanks - I got it

    Excellent!  Thanks - I got it to work!

    Report
  4. 0
    Zoltan Palffy ·
    #4

    glad I could help

    glad I could help 

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?