I really like the presentation of "Days Delinquent" on the AR Aged Invoice Report and would like to do the same on the AR Statements.
My problem is trying to find a good field that equals the "Statement Date" (with cut-off ability). What I've done so far is to create a formula field called "DaysDelinquent" with the following formula:
IF (DateDiff ("d",{AR_StatementWrk.InvoiceDueDate},{@StatementDate}) > 0) Then
(DateDiff ("d",{AR_StatementWrk.InvoiceDueDate},{@StatementDate}))
Else (0);
But I get a Crystal Reports error saying "A date is required here" and it highlights the @StatementDate field. I suspect that's because that field is a TEXT representation of the statement date and isn't a real date field.
How can I get the StatementDate that's entered at the time the report is run to be used in this formula?
Any ideas?