Hello! I have a table Calls like this:
| Call Date DD MM YYYY | Abonent |
|---|
| 01.01.15 | 1 |
| 02.01.15 | 1 |
| 03.01.15 | 2 |
| 04.01.15 | 1 |
Table sorted accending by Call Date.
For each call record i want calculate two fields:
How many days passed since last call from abonent,
How many days passed before next call happens.
For example, for Call at 02.01.15 I weant to see: 1 day from last call, 2 days before next call.
How to do this? I have not Idea.
