Oracle Primavera - PM6 Member for 16 years 3 months Member for 16 years 3 months Submitted by Zoltan Palffy on Tue, 2020-11-24 14:06 Permalink glad I could help glad I could help Member for 6 years 9 months Member for 6 years 9 months Submitted by hhadley on Mon, 2020-11-23 14:38 Permalink Excellent! Thanks - I got it Excellent! Thanks - I got it to work! Member for 16 years 3 months Member for 16 years 3 months Submitted by Zoltan Palffy on Fri, 2020-11-20 14:06 Permalink 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 Member for 20 years 6 months Member for 20 years 6 months Submitted by Santosh Bhat on Thu, 2020-11-19 23:21 Permalink 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. Log in or register to post comments
Member for 16 years 3 months Member for 16 years 3 months Submitted by Zoltan Palffy on Tue, 2020-11-24 14:06 Permalink glad I could help glad I could help
Member for 6 years 9 months Member for 6 years 9 months Submitted by hhadley on Mon, 2020-11-23 14:38 Permalink Excellent! Thanks - I got it Excellent! Thanks - I got it to work!
Member for 16 years 3 months Member for 16 years 3 months Submitted by Zoltan Palffy on Fri, 2020-11-20 14:06 Permalink 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
Member for 20 years 6 months Member for 20 years 6 months Submitted by Santosh Bhat on Thu, 2020-11-19 23:21 Permalink 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.
Member for
16 years 3 monthsglad I could help
glad I could help
Member for
6 years 9 monthsExcellent! Thanks - I got it
Excellent! Thanks - I got it to work!
Member for
16 years 3 monthsyou 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
Member for
20 years 6 monthsHeather, 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:
Your filters will need to be (OR) for all the above scenarios.