date issues in formula

[grecon]

I am doing a Accounts Receivable Report and I only want to pick up customers that are over 30 days past due but I don't know haow to reference that in a formula. What do I use as a date to say when the ship date is over 30 days Right now I have this

not {ORDERHDR.PROFORMA} and
not {ORDERHDR.CANCELLED} and
not {INVOICE.BADDEBT_FL} and
{INVOICE.BALANCE} > {?Minimum Balance} and
{INVOICE.SHIPPED_DT} > Date (1899, 12, 31) and
{@ARDESCR} <> "0-30" and
not {ORDERHDR.TEMPSAVE}

but is is still pulling some that are 0-30 and putting them as 30-60 Any Suggestions?

 

[grecon]

To put it simply I want only customers who have a invoice date 30 days or more past the ship date and put them in the 30-60 60-90 and 90and over range since that would them overdue.

 

[Madawc]

DateDiff will tell you the difference between two dates, using various units including days. HELP will give you its details.

I suggest you put the command in its own formula field, and display it with unselected data to confirm it is correct. Then add a test to the selection.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP