topic calculate the number of months between two dates in QlikView https://community.qlik.com/t5/QlikView/calculate-the-number-of-months-between-two-dates/m-p/308242#M586901 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>how to calculate the number of months between two dates ? </P><P></P><P></P><P></P><P>Any help would be greatly appreciated. Thank you!</P><P></P><P>Red</P></BODY></HTML> Tue, 26 Jul 2011 14:10:18 GMT 2011-07-26T14:10:18Z calculate the number of months between two dates https://community.qlik.com/t5/QlikView/calculate-the-number-of-months-between-two-dates/m-p/308242#M586901 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>how to calculate the number of months between two dates ? </P><P></P><P></P><P></P><P>Any help would be greatly appreciated. Thank you!</P><P></P><P>Red</P></BODY></HTML> Tue, 26 Jul 2011 14:10:18 GMT https://community.qlik.com/t5/QlikView/calculate-the-number-of-months-between-two-dates/m-p/308242#M586901 2011-07-26T14:10:18Z calculate the number of months between two dates https://community.qlik.com/t5/QlikView/calculate-the-number-of-months-between-two-dates/m-p/308243#M586903 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>you can try this :</P><P></P><P>SubStringCount(concat(DISTINCT MonthName(OrderDate)&amp;';'),';')</P><P></P><P>regards,</P><P></P><P>Valentin</P></BODY></HTML> Tue, 26 Jul 2011 14:25:43 GMT https://community.qlik.com/t5/QlikView/calculate-the-number-of-months-between-two-dates/m-p/308243#M586903 2011-07-26T14:25:43Z calculate the number of months between two dates https://community.qlik.com/t5/QlikView/calculate-the-number-of-months-between-two-dates/m-p/308244#M586904 <HTML><HEAD></HEAD><BODY><P>You can try something basic like floor((date_to - date_from)/30). But maybe that's just too basic.</P></BODY></HTML> Tue, 26 Jul 2011 14:29:20 GMT https://community.qlik.com/t5/QlikView/calculate-the-number-of-months-between-two-dates/m-p/308244#M586904 danielrozental 2011-07-26T14:29:20Z