Getting The No. of months between subsequent Posting Dates

Freaky · 2010-01-08

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 · 2010-01-08

Have you considred using the DATE2DMY function?

Marije_Brummel · 2010-01-08

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 · 2010-01-08

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 · 2010-01-08

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 · 2010-01-08

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 · 2010-01-08

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

Freaky · 2010-01-08

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

=D>

Marije_Brummel · 2010-01-08

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

lvanvugt · 2010-01-09

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.

Getting The No. of months between subsequent Posting Dates

Answers

Categories