https://community.qlik.com/t5/QlikView/Date-subtraction-amp-nulls/m-p/1586364#M739989 <P>Rangesum(<SPAN>resolution date, - created date)</SPAN></P> Wed, 29 May 2019 18:06:49 GMT m_woolf 2019-05-29T18:06:49Z https://community.qlik.com/t5/QlikView/Date-subtraction-amp-nulls/m-p/1586305#M739988 <P>Hi,</P><P>I am trying to subtract 2 dates but one of the fields sometimes has no dates. This gives me a strange result where&nbsp; I get a large minus figure such as -2174. How can I deal with this? This is the expression I have used:</P><P>resolution date - created date</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="subtract.PNG" style="width: 386px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/12889i3B9803AEFC69DF7D/image-size/large?v=v2&amp;px=999" role="button" title="subtract.PNG" alt="subtract.PNG" /></span></P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-subtraction-amp-nulls/m-p/1586305#M739988 Folarin 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Date-subtraction-amp-nulls/m-p/1586364#M739989 <P>Rangesum(<SPAN>resolution date, - created date)</SPAN></P> Wed, 29 May 2019 18:06:49 GMT https://community.qlik.com/t5/QlikView/Date-subtraction-amp-nulls/m-p/1586364#M739989 m_woolf 2019-05-29T18:06:49Z https://community.qlik.com/t5/QlikView/Date-subtraction-amp-nulls/m-p/1586397#M739990 <P><SPAN>Alt(resolution date, today(2)) - created date</SPAN></P><P>-Rob<BR /><A href="http://masterssummit.com" target="_blank">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank">http://qlikviewcookbook.com</A><BR /><A href="http://www.easyqlik.com" target="_blank">http://www.easyqlik.com</A></P> Wed, 29 May 2019 19:20:57 GMT https://community.qlik.com/t5/QlikView/Date-subtraction-amp-nulls/m-p/1586397#M739990 rwunderlich 2019-05-29T19:20:57Z