topic AW:Difference between two dates? in QlikView https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/165773#M37971 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>use the expression month(field1)-month(field2)</P></BODY></HTML> Wed, 18 Aug 2010 11:23:45 GMT brenner_martina 2010-08-18T11:23:45Z Difference between two dates? https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/165772#M37970 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have two dates stored in two object text.</P><P>I want to obtain the number of months between theses two dates?</P><P>How i proceed?</P><P>Thnks</P></BODY></HTML> Wed, 18 Aug 2010 11:20:35 GMT https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/165772#M37970 2010-08-18T11:20:35Z AW:Difference between two dates? https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/165773#M37971 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>use the expression month(field1)-month(field2)</P></BODY></HTML> Wed, 18 Aug 2010 11:23:45 GMT https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/165773#M37971 brenner_martina 2010-08-18T11:23:45Z Difference between two dates? https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/165774#M37972 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>The complete expression is:</P><P>(Year(End_Date)-Year(Init_Date))*12 + Num(Month(End_Date))- Num(Month(Init_Date))</P><P>Regards.</P></BODY></HTML> Wed, 18 Aug 2010 11:29:46 GMT https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/165774#M37972 2010-08-18T11:29:46Z Difference between two dates? https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/165775#M37973 <HTML><HEAD></HEAD><BODY><P>use this</P><P>round((date1-date2)/30)</P></BODY></HTML> Wed, 18 Aug 2010 11:46:08 GMT https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/165775#M37973 2010-08-18T11:46:08Z