topic Re: Formula to find value between dates in QlikView https://community.qlik.com/t5/QlikView/Formula-to-find-value-between-dates/m-p/454323#M169520 <HTML><HEAD></HEAD><BODY><P>How about:</P><P></P><P>max([Picking Date]) - min(Created On])</P></BODY></HTML> Thu, 25 Oct 2012 15:44:58 GMT fosuzuki 2012-10-25T15:44:58Z Formula to find value between dates https://community.qlik.com/t5/QlikView/Formula-to-find-value-between-dates/m-p/454322#M169519 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>Say, for instance, I had the following values:</P><P></P><P></P><P>DOC NUMBER:&nbsp;&nbsp;&nbsp;&nbsp; DELIVERY NUMBER:&nbsp;&nbsp;&nbsp;&nbsp; [CREATED ON]:&nbsp;&nbsp;&nbsp;&nbsp; [PICKING DATE]:&nbsp;&nbsp;&nbsp; </P><P>&nbsp; 124578&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A124578&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012.06.01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012.06.01&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B124578&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012.06.01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012.06.03</P><P></P><P>What kind of formula would I use to calculate the number of days the DOC_NUMBER takes to process inbetween [Created on] date and [Picking date]?</P><P></P><P>In this case I would looking for the value 2.</P><P></P><P>Any help would be greatly appreciated</P><P></P><P>Thanks</P></BODY></HTML> Thu, 25 Oct 2012 15:12:25 GMT https://community.qlik.com/t5/QlikView/Formula-to-find-value-between-dates/m-p/454322#M169519 2012-10-25T15:12:25Z Re: Formula to find value between dates https://community.qlik.com/t5/QlikView/Formula-to-find-value-between-dates/m-p/454323#M169520 <HTML><HEAD></HEAD><BODY><P>How about:</P><P></P><P>max([Picking Date]) - min(Created On])</P></BODY></HTML> Thu, 25 Oct 2012 15:44:58 GMT https://community.qlik.com/t5/QlikView/Formula-to-find-value-between-dates/m-p/454323#M169520 fosuzuki 2012-10-25T15:44:58Z