Number of month

bassouma · 2014-06-18

Hello,

I want to calculate number of month from a period.
For example:start day=01/02/13 period =2Y(dateformula)
so how can i calculate the number of month for this period
The result shoud be 24 moth.

Thanks

majormarcell1988 · 2014-06-18

Hi,

You might want to look at the Date table (you can only see it if you create a page/form), filtered by month and period start and end. This might give you what you need.

Marcell

jglathe · 2014-06-18

How about DATE2DMY(MyDate,2) ?

einsTeIn.NET · 2014-06-18

I think Jens' idea leads you on the right track. The only thing you need to consider is that it could be different years. Maybe something like this...?

RefDate := CALCDATE('<2Y>',StartDate);
NoOfMonths := (DATE2DMY(StartDate,3) - DATE2DMY(RefDate,3)) * 12;
NoOfMonths += (DATE2DMY(StartDate,2) - DATE2DMY(RefDate,2));

kine · 2014-06-19

majormarcell1988 wrote:

Hi,

You might want to look at the Date table (you can only see it if you create a page/form), filtered by month and period start and end. This might give you what you need.

Marcell

This is best idea. Set the period to month, filter start and end (depends on you if you want to count the months which are not full or only the full months in the period), and the result is Date.Count... easy and fast...

Number of month

Comments

Categories