Query If formula

[deejabram]

I am looking for some help writing a formula.

Briefly, I have "X" amount of employees who are on "Light Duty". I would like to create a report which shows (by bargining unit) who has been on Light Duty for Over a Year, 91 days to a year, or 90 days or less based on their "Start Date" which I do have recorded.

I already made the query. I assume will have to add a (Now) formula in there, which I have done. From there I am assuming it is an Ifn function, but I am not all that good with that.

I appreciate any assistance anyone can offer.

-DJ

 

[DCrake]

How are you recording that the person is on light duty? do you have a field that is updated or is this based on a calculation between two dates?

If the latter how are you handling multiple instances of light duty.

 

[deejabram]

I have a field which indicates whether it is an open or closed case.

In this instance it is not important to seperate the closed cases. I am only interested in creating the reports for all Open cases. My fields in this query are

CaseOpen? (Self Explaintory)
PayPlan (Self Explaintory)
Site (Location - my organization is spread out in different cities)
DateRestrictionBegan (Start Date of Light Duty Status)
BarginingUnit - Self Explaintory

TodaysDate: the now function

 

[deejabram]

One more thing: The Case Open field is set for the Criteria of Like 'Yes'