Doing a count on yesterday's date in a report

[skaggsal]

I am creating a report in Crystal that has three different counts. It is for open help desk tickets. One colum is just a count for all open tickets and I got that one done. The next column, I am having some troubles with. I need to count all tickets that were opened yesterday. I do have an open date field that I am using and I created a formula to convert it from date and time to just date. Now I want to do a count on all of the dates that are yesterday's date. I tried doing a {@Ticket Date} = currentdate-1 but it gives me a true/false instead of actual date. How can I get it to pull only the date so I can do a count?

Thanks!
Angie

 

[ianoctdec]

Hi

if {@Ticket Date} = currentdate-1 then
1
else
0

Insert a sum on this formula. This should give you your count.

Dana

 

[skaggsal]

It worked! Thank you so much!!!!