find a duration in months

[marwen_garwachi]

Hello,

I need to calculate duration between two dates in months, somone can help me please ?

Exemple :

Start date :  11/07/2007

End Date : 04/11/2013

Elapsed => 75 months 

Thank you

[Clever_Anjos]

this should return what you want

=year(vDate1)*12+month(vDate1) -  (year(vDate2)*12+month(vDate2))

[Clever_Anjos]

Or this expression that convert days to months

=  Floor(year(vDate1)*12+month(vDate1)+day(vDate1)/30 

-  (year(vDate2)*12+month(vDate2)+day(vDate2)/30))

[marwen_garwachi]

This works but not with all fields i don't know why

=  Floor(year(vDate1)*12+month(vDate1)+day(vDate1)/30

-  (year(vDate2)*12+month(vDate2)+day(vDate2)/30))

Now for this formula the results are wrong

=year(vDate1)*12+month(vDate1) -  (year(vDate2)*12+month(vDate2))

[Clever_Anjos]

Could you post a qvw? I´ll check this

[jaimeaguilar · Accepted solution]

Hi,

Try

12*(Year(EndDate)-Year(StartDate))+(Month(EndDate)-Month(StartDate)) )

regards

[marwen_garwachi]

That works Jaime Aguilar !! Thanks a lot .

Clever Anjos Thanks a lot too .