Getting The No. of months between subsequent Posting Dates

Freaky

Hi Guys,
I designed a report to print out Posting dates of a customer with payments and arrears.
Now, what I want is to be able to get the difference between subsequent months. Please take a look below

Months
29/02/08
03/04/08
21/05/08
18/06/08
17/09/08


Desired Result
No. of Months
0
2
1
1
3


Please can anyone help me on this.
Thanks.

lvanvugt

Have you considred using the DATE2DMY function?

Marije_Brummel

And what is wrong with your calculations? Is this the result of your code or the desired results?

Have you looked at the DATE2DMY function or using the virtual date table?

Freaky

Sorry did not make it clear the No. of Months is my desired result. That is what I cannot figure out how to get.

Thanks.

Marije_Brummel

So? Start investigating our suggestions and come back with some C/AL code if you cannot get it to work.

This website is not a free development site, we give hints and you should be able to figure out yourself what to do and learn in this process.

Good luck!

Freaky

ok I did work onthe following code though not bad but did not give me what i want.

START :=("Cust. Ledger Entry"."Posting Date");

IF "Cust. Ledger Entry1".NEXT() <> 0 THEN BEGIN
enddate :=("Cust. Ledger Entry1"."Posting Date");
diff := ABS(enddate - START);
END
ELSE BEGIN
diff:= 0;
END;

the diff variable gives me the difference in days which I can convert to months

Dates
01/01/2007
31/03/2007
29/10/2007
30/11/2007
24/12/2007
31/01/2008
29/02/2008


diff
0
145

---

> This is the only wrong figure am getting
212
32
24
38
29


The 145 days should be about 60 days. Can you guys help in figuring it out. Please.
Thanks.

Marije_Brummel

And what if you replace your calculation with the DATE2DMY statement?

Freaky

Thanks guys I was enable to figure get it using the DATE2DMY FUNCTION.

=D>

Marije_Brummel

Perfect! Job done... next job...

lvanvugt

Glad to have been able to help you. Good luck.

BTW: great that you changed the status to solved as so many fellow mibuso-ers seem to forget to do that.