topic Re: DateDiff in QlikView https://community.qlik.com/t5/QlikView/DateDiff/m-p/1370633#M418992 <HTML><HEAD></HEAD><BODY><P>Try like </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Num(Year(Date1)) - Num(Year(Date2)) --&gt; gives the Yeardiff</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Num(Month(Date1)) - Num(Month(Date2)) --&gt; gives the Monthdiff</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Num(Week(Date1)) - Num(Week(Date2)) --&gt; gives the Weekdiff</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Num(Date1) - Num(Date2)) --&gt; gives the Daydiff</SPAN></P></BODY></HTML> Wed, 09 Aug 2017 07:37:03 GMT prma7799 2017-08-09T07:37:03Z DateDiff https://community.qlik.com/t5/QlikView/DateDiff/m-p/1370632#M418991 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/group/1007">Qlik Brasil</A> favor, saberia me dizer se esta informação procede:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">infelizmente o QV não tem uma função pronta que calcula o número de meses entre duas datas, como por exemplo o DateDiff() do SQL...</P></BODY></HTML> Tue, 08 Aug 2017 17:44:35 GMT https://community.qlik.com/t5/QlikView/DateDiff/m-p/1370632#M418991 Anonymous 2017-08-08T17:44:35Z Re: DateDiff https://community.qlik.com/t5/QlikView/DateDiff/m-p/1370633#M418992 <HTML><HEAD></HEAD><BODY><P>Try like </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Num(Year(Date1)) - Num(Year(Date2)) --&gt; gives the Yeardiff</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Num(Month(Date1)) - Num(Month(Date2)) --&gt; gives the Monthdiff</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Num(Week(Date1)) - Num(Week(Date2)) --&gt; gives the Weekdiff</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Num(Date1) - Num(Date2)) --&gt; gives the Daydiff</SPAN></P></BODY></HTML> Wed, 09 Aug 2017 07:37:03 GMT https://community.qlik.com/t5/QlikView/DateDiff/m-p/1370633#M418992 prma7799 2017-08-09T07:37:03Z Re: DateDiff https://community.qlik.com/t5/QlikView/DateDiff/m-p/1370634#M418993 <HTML><HEAD></HEAD><BODY><P>Or check this</P><P></P><P><A href="https://community.qlik.com/docs/DOC-3836">Calculating Months difference between two dates</A></P></BODY></HTML> Wed, 09 Aug 2017 07:37:53 GMT https://community.qlik.com/t5/QlikView/DateDiff/m-p/1370634#M418993 prma7799 2017-08-09T07:37:53Z