Filter Select using IF Formula

[dcrosier]

I have created the following formula to filter my data out. What I am attempting to do is to show the job only if there is a current problem. I have setup the formula to reverse the workflow. ie. The last task to be completed is tested first.

if {FactSched} < currentdate or {FactSched} < {FactStart}then true
    08/02/01    08/14/01    08/02/01    07/27/01

else if {CutSched} < currentdate or {CutSched} < {CutStart}then true
    07/25/01    08/14/01    07/25/01    07/31/01

else if {MtlSched} < currentdate or {MtlSched} < {MtlStart}then true
    07/18/01    08/14/01    07/18/01    07/24/01

else if {EngSched} < currentdate or {EngSched} < {EngStart}then true
    No Date    08/14/01    No Date    No Date

else if {PurchSched} < currentdate or {PurchSched} < {PurchStart}then true
    05/17/01    08/14/01    05/17/01    06/06/01

The dates are there so that you can see the data. My problem is that this job is showing up on the report and I don't understand why.

HELP!!!! (I apologize for posting in two separate forums.)

 

[JustineB]

It will show up because the first argument is true (as is the second, third and fifth.
Did you want all 5 parts of the formula to be True before the filter takes place? at the moment, it is only looking at the first part of the formula.
Or have I missed something obvious? Sorry if so!
Justine

 

[dcrosier]

What I wanted was to have the test determin whether the job process was late by looking at both the Scheduled Date and the Actual Date. It needs to compare the Scheduled Date against the Current Date. If the Scheduled Date is less than the Current Date, I also need it to compare the Scheduled Date against any Actual Time posted against it. The Whole Job is late if the last Time posted against the job is considered late.

My thought was to look at the last process first. That is why I built the IF statement in reverse. So, in this scenario the job was:
- Purchasing = Late - Appear on Report
- Engineering = Ignore - Not part of the Work Flow of this job.
- Material = Late - Still Appear on the Report
- Cutting = Late - Still Appear on the Report
- Factory = Early - Fall off the Report

I need to be able to have Jobs on the Report if they are late in their work process and fall off the report if they get back on track.

Any thoughts?

Thanks.
Dawn