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.
0
Answers
Never stop learning
Van Vugt's dynamiXs
Dutch Dynamics Community
Have you looked at the DATE2DMY function or using the virtual date table?
Thanks.
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!
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.
=D>
BTW: great that you changed the status to solved as so many fellow mibuso-ers seem to forget to do that.
Never stop learning
Van Vugt's dynamiXs
Dutch Dynamics Community