Printing a form notice by the number of days past due.

[terenceb]

Hi All,

I am using Crystal 8.5 pulling data from sql tables from Cashe database. I have created 3 notices in Group footer 2a,2b & 2c. These letters should print if the client has gone 3 months, 4 months and 5 months,respectively, without a payment. I have tried supressing two of the notices if one of them is true. My problem is if a client has gone 3 months without a payment they could also be 4 or 5 months past due also. This the type of supression formula I used {bill_payment_data.date_of_payment} < Dateadd ("m",-3,currentdate).

 

[lbass]

I think you would have to use ranges, as in:

//suppression for 3-month notice:
not({bill_payment_data.date_of_payment} in
Dateadd ("m",-4,currentdate)+1 to Dateadd ("m",-3,currentdate))

//suppression for 4-month notice:
not({bill_payment_data.date_of_payment} in
Dateadd ("m",-5,currentdate)+1 to Dateadd ("m",-4,currentdate))

//suppression for 5-month notice:
not({bill_payment_data.date_of_payment} <
Dateadd ("m",-5,currentdate)

-LB