topic How to calculate a 'middle date' from 2 other dates ? Help please :-) in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-a-middle-date-from-2-other-dates-Help-please/m-p/225440#M77747 <HTML><HEAD></HEAD><BODY><P>Superb - thanks very much !! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Thu, 16 Dec 2010 15:01:26 GMT 2010-12-16T15:01:26Z How to calculate a 'middle date' from 2 other dates ? Help please :-) https://community.qlik.com/t5/QlikView/How-to-calculate-a-middle-date-from-2-other-dates-Help-please/m-p/225437#M77744 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table like this..</P><P>Item A Delivery from 01/01/10 Delivery to 01/02/10</P><P>I am looking for some thing script wise that would give me the 'mid date' i.e 15/01/10</P><P>Was thinking convert date to numbers, then ((MAX DATE - MIN DATE) / 2) + MIN DATE &amp; then convert number back date, but</P><P>a) not sure if this is the best approach and</P><P>b) can't find the function to convert dates to numbers</P><P></P><P>Any ideas please - help gratefully received <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>Thanks</P><P>Bob</P><P></P><P></P></BODY></HTML> Thu, 16 Dec 2010 14:07:17 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-a-middle-date-from-2-other-dates-Help-please/m-p/225437#M77744 2010-12-16T14:07:17Z How to calculate a 'middle date' from 2 other dates ? Help please :-) https://community.qlik.com/t5/QlikView/How-to-calculate-a-middle-date-from-2-other-dates-Help-please/m-p/225438#M77745 <HTML><HEAD></HEAD><BODY><P>recently i resolve same type of issue with the help of <STRONG>interval match</STRONG>.</P></BODY></HTML> Thu, 16 Dec 2010 14:12:14 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-a-middle-date-from-2-other-dates-Help-please/m-p/225438#M77745 suniljain 2010-12-16T14:12:14Z How to calculate a 'middle date' from 2 other dates ? Help please :-) https://community.qlik.com/t5/QlikView/How-to-calculate-a-middle-date-from-2-other-dates-Help-please/m-p/225439#M77746 <HTML><HEAD></HEAD><BODY><P></P><P></P><P>=</P><P>date(rangesum(<B>MinDate</B>,<B>MaxDate</B>)/2)</P><BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 16 Dec 2010 14:42:38 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-a-middle-date-from-2-other-dates-Help-please/m-p/225439#M77746 2010-12-16T14:42:38Z How to calculate a 'middle date' from 2 other dates ? Help please :-) https://community.qlik.com/t5/QlikView/How-to-calculate-a-middle-date-from-2-other-dates-Help-please/m-p/225440#M77747 <HTML><HEAD></HEAD><BODY><P>Superb - thanks very much !! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Thu, 16 Dec 2010 15:01:26 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-a-middle-date-from-2-other-dates-Help-please/m-p/225440#M77747 2010-12-16T15:01:26Z