https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/1761173#M4237 <P>Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.</P><P>Fyi, difference in days can calculated with subtraction and <A href="https://help.qlik.com/en-US/sense/latest/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunctions/Interval.htm" target="_self">Interval</A> can format to hours, min, secs&nbsp;</P><P>Thanks,</P><P>Patric</P> Thu, 12 Nov 2020 14:01:00 GMT Patric_Nordstrom 2020-11-12T14:01:00Z https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idi-p/1756870 <P>Hello all,<BR /><BR />Datediff is a very, very common function in every BI Tools I know, from SQL (<A href="https://docs.microsoft.com/fr-fr/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver15" target="_blank" rel="noopener">https://docs.microsoft.com/fr-fr/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver15</A> ) to competitors products.<BR /><BR />The concept is simple :</P><PRE><SPAN><SPAN class="hljs-keyword">DATEDIFF</SPAN> ( datepart , startdate , enddate ) </SPAN></PRE><P>where datepart can be month, week, year and so on. It's very useful, especially with month or years that can have a variagle length(28-31 and 365-366 days).&nbsp;<BR /><BR />Best regards,<BR /><BR />Simon</P> Wed, 25 Nov 2020 08:50:26 GMT https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idi-p/1756870 simonaubert 2020-11-25T08:50:26Z https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/1756880#M3966 <P>Great idea <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/54230">@simonaubert</a>&nbsp;. It will be very helpful.</P> Wed, 28 Oct 2020 21:48:44 GMT https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/1756880#M3966 marcel_olmo 2020-10-28T21:48:44Z https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/1761173#M4237 <P>Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.</P><P>Fyi, difference in days can calculated with subtraction and <A href="https://help.qlik.com/en-US/sense/latest/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunctions/Interval.htm" target="_self">Interval</A> can format to hours, min, secs&nbsp;</P><P>Thanks,</P><P>Patric</P> Thu, 12 Nov 2020 14:01:00 GMT https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/1761173#M4237 Patric_Nordstrom 2020-11-12T14:01:00Z https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/1761187#M4245 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/24514">@Patric_Nordstrom</a>Hello. Yep, I already use substraction for days or hours... I can divide by 7 for weeks but my difficulty is more with months or years that have variable length.</P><P>Moreover, this function is a standard in the industry.<BR /><BR />Best regards,<BR /><BR />Simon<BR /><BR /><BR /></P> Thu, 12 Nov 2020 14:14:22 GMT https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/1761187#M4245 simonaubert 2020-11-12T14:14:22Z https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/1784222#M5139 <P>good idea</P> Fri, 19 Feb 2021 15:15:22 GMT https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/1784222#M5139 Olivier_W 2021-02-19T15:15:22Z https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/2006504#M10848 <P>Wäre sehr hilfreich. Gute Idee.</P> Fri, 18 Nov 2022 15:57:49 GMT https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/2006504#M10848 Hanspeter 2022-11-18T15:57:49Z https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/2100716#M13966 <P>From now on, please track this idea from the Ideation portal.&nbsp;</P><P><STRONG><A title="Link to new idea" href="https://ideation.qlik.com/app/#/case/301118" target="_blank" rel="noopener">Link to new idea</A></STRONG></P><P>Meghann</P><P data-unlink="true"><EM>NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you <STRONG>only</STRONG> see 1 tab with the login page, please try clicking this link first: <STRONG><A title="Authenticate me!" href="#" target="_blank" rel="noopener">Authenticate me!</A></STRONG>&nbsp;t</EM><EM>hen try the link above again. Ensure pop-up blocker is off.</EM></P> Wed, 02 Aug 2023 15:49:08 GMT https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/2100716#M13966 Meghann_MacDonald 2023-08-02T15:49:08Z https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/2100717#M13967 Wed, 02 Aug 2023 15:49:10 GMT https://community.qlik.com/t5/Suggest-an-Idea/New-function-Datediff-to-have-the-difference-between-two-dates/idc-p/2100717#M13967 Ideation 2023-08-02T15:49:10Z