Link to home
Start Free TrialLog in
Avatar of cdmccoy
cdmccoyFlag for United States of America

asked on

Crystal Date

I would like to count the number of open incidents that come in prior days ONLY e.g day1, day2, day3 from the ?Assignment Date.  The formula that I used for day1 is:  The ?assignment Date = 5/15 which works... I can not get the day2 which would be all 5/14 only.  
NumberVar Day1;

If {Task.CreatedDateTime} <= {?Assignment Date} and {Task.CreatedDateTime} >=

DateAdd ("d", -1, {?Assignment Date})and

{Task.Status} in ["accepted", "Waiting"]
then Day1 := Day1 + 1;
Avatar of Mike McCracken
Mike McCracken

I am not sure I follow what you want done.  Can you provide some sample data and show what the results wuld be.

Avatar of James0628

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial