Day diffrence between two records

[RobertLees]

Hi

I am populating a ListView, in the following loop...

Do Until .GotLastRow()
Loop

On each row, I have a date column. I would like to add another column which shows the number of days between one row and the next row. I would also have to avoid the error which would probably happen at the final row - there won't be a "next".

Thanks
Robert

[randem]

RobertLees,

Simple read each row and fill two data items with the date. You alternate between then using a counter that will alternate between 1 and 2. When the counter is two you calculate the date using The DateDiff Function.