topic Re: Formula for difference between two dates in months in QlikView

Formula for difference between two dates in months

Wed, 18 Sep 2013 09:42:48 GMT

I'm trying to create a formula that will tell me the difference between a start date in whole months.

e.g. Start Date 15/07/12, End Date 2/12/13

This should result in 18 months, as regardless of the day it starts/finishes, the whole month counts as one, i.e. a Start date of the 1st is treated the same as if it were the 31st.

I've tried using interval but it doesn't seem to come out with the results I want. Does anyone have any suggestions?

Thanks

Steve

Re: Formula for difference between two dates in months

Wed, 18 Sep 2013 09:54:58 GMT

(Year(enddate)-Year(startdate))*12+13-month(startdate)-(12-month(enddate))

Re: Formula for difference between two dates in months

Gysbert_Wassenaar — Wed, 18 Sep 2013 10:05:56 GMT

See this discussion: How Do I Get the Number of Months Between Two Dates?

Re: Formula for difference between two dates in months

Wed, 18 Sep 2013 10:52:11 GMT

Hmmm, I'm a little annoyed with myself for not coming up with this on my own. I think I was over complicating matters when a simple formula would do what I want.

Many thanks for spotting this and helping me out.

Steve

Re: Formula for difference between two dates in months

Wed, 18 Sep 2013 11:33:47 GMT

No worries, that's what this forum is for!