STORE THE DATE IN ONE RECORD TO GET #DAYS 1

[rmill]

I could have 3 or more invoices for one account..I want to know the number of days between each invoice..each on a separate line and show each line..please

 

[mmaz]

I don't have Crystal Reports installed on my computer right now so I can't tell you the exact syntax, but here's how you could do it.

Group the report by account and order the report by date of invoice, then create a formula, and subtract the date of the previous invoice from the date of current record. Drop the formula on your report, and voilà!

HTH!

 

[mmaz]

There's a Crystal Reports built-in function, I think it's called "prev" or "previous" (there's another called "next&quot. So when your report is processing a record, you can get the information from the previous or the next record.

Marie