topic Re: find a duration in months in QlikView

find a duration in months

marwen_garwachi — Tue, 05 Nov 2013 15:14:17 GMT

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 — Tue, 05 Nov 2013 15:17:21 GMT

this should return what you want

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

Clever_Anjos — Tue, 05 Nov 2013 15:20:53 GMT

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 — Tue, 05 Nov 2013 15:45:26 GMT

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 — Tue, 05 Nov 2013 15:47:29 GMT

Could you post a qvw? I´ll check this

jaimeaguilar — Tue, 05 Nov 2013 15:54:10 GMT

Hi,

Try

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

regards

marwen_garwachi — Tue, 05 Nov 2013 16:42:42 GMT

That works Jaime Aguilar !! Thanks a lot .

Clever Anjos Thanks a lot too .