How to refer to previous fields in 2 different row

[Ivan H.]

HI there!
I'm new in Crystal Report programming. I have a report that generates dates in rows. I would like to calculate the different between 2 dates. For example, I would like to calculate the different dates between 1st row and 2nd row, 2nd row and 3rd row etc. The dates are from Access database and printed in Detail section. Thank you.

[brucevde]

In Crystal you can access the record before and after the current record using the Previous (it might be just Prev) and Next functions. So in your case create a formula and use the Previous function. Something like

DateDiff(X, {TableName.FieldName}, Previous({TableName.FieldName}))

[Ivan H.]

Thank you Bruce! It works.
Ivan H.

[shakti5385]

Thank you Bruce! It works.
Ivan H.

If you Got the solution then go to the thread tool menu and click on the resolved this thread so people know that it is resolved

[mabbas110]

Good Solution.