Hello,

I am new to this forum. And relatively new to Crystal.

I am using Crystal 11. I need to get a count of tickets that were closed within 3 days. I have a {ClosedDate} field that is a string. I am not sure the plan of attack to take here.

I have tried creating a formula to convert the string to a date and then to the correct date format seen below.

If datediff("d", cdate(ToText(cDate({CallLog.ClosedDate}),"MM/dd/yyyy")),cdate(ToText(cDate({?Date T0}),"MM/dd/yyyy"))) >3 then "1" else "0"

I also tried simplifying it to (Date({CallLog.ClosedDate}) = (CurrentDate-3))

None of which are working for me. I hope this is clear. Its hard to relay something when you arent really sure what you are talking about.

Any help would be great!! Thanks

I am trying to compare RcvdDate to ClosedDate.

I need to know tickets that were closed within 3 days of the RcvdDate, as well as 5Days, and Greater than 5 days. The format of the date string is YYYY-MM-DD.

When I create a formula like the one mentioned above and add it to a Running total formula I get "Bad Date Format"