I am having trouble with a formula which is producing an error. The formula shows no error when it is checked and saved. I can put it into the detail area of the report and it operates fine. The error only appears if I try to do a summary of the field in the report. The error message is "Bad date-time format string." Here is the formula: Local DateTimeVar d1 := {Gf_Date}; Local DateTimeVar d2 := CurrentDateTime; Local DateTimeVar d3 := CDateTime ({Gf_Gift_status_date}); Local NumberVar n1 := 1; if {Gf_Gift_status} <> "Active" then n1 := DateDiff("m", d1, d3) else n1 := DateDiff("m", d1, d2); if {Gf_Type} = "Recurring Gift" then CCur ({Gf_Amount} * n1) else if {Gf_Type} = "Pledge" then {Gf_Amount} else 0.00 The report is to calculate the projected gifts for both recurring gifts and pledges and then it compares it to the actual gift totals. This formula is for the projected gifts part. Does anyone have any ideas on what is causing the error and how to fix it? If not, does anyone have a solution for calculating expected giving for recurring gifts in a certain time period that they would be willing to share? Thanks for the help.

The Gift Status Date is a fuzzy date. It can be in one of three formats "MM/DD/YYYY", "MM/YYYY", or "YYYY". Your formula is only accounting for this first format, so you are getting errors for a date in one of the other formats. Drew J. Drew Allen Children's Hospital of Philadelphia [Email Removed] Check out the user run RE Forum at http://www.blackbus.org/ . Check out the Crystal Reports blog "Crystal Clear" at http://www.blackbus.org/blogs/viewblog.php?userid=63