cdmccoy
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.
WhilePrintingRecords;
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;
WhilePrintingRecords;
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;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mlmcc