topic Earliest date in QlikView https://community.qlik.com/t5/QlikView/Earliest-date/m-p/733927#M475140 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a file with customer information</P><P></P><P>NI number</P><P>Forename</P><P>Surname</P><P>Date purchased car</P><P>Date purchased house</P><P>Date purchased van</P><P></P><P>I'd like to be able to pull out the earliest date between date purchased car, date purchased house and date purchased van. For example see below</P><P></P><TABLE border="1" class="jiveBorder" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 100%; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>NI num</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Forename</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Surname</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Date purchased car</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>date purchased house</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Date purchased van</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Earliest</STRONG></TH></TR><TR><TD style="padding: 2px;">111111</TD><TD style="padding: 2px;">Bob</TD><TD style="padding: 2px;">Smith</TD><TD style="padding: 2px;">01/01/2014</TD><TD style="padding: 2px;">05/05/2014</TD><TD style="padding: 2px;">01/08/2014</TD><TD style="padding: 2px;">01/01/2014</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Can this be done?</P></BODY></HTML> Thu, 07 Aug 2014 15:44:39 GMT Anonymous 2014-08-07T15:44:39Z Earliest date https://community.qlik.com/t5/QlikView/Earliest-date/m-p/733927#M475140 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a file with customer information</P><P></P><P>NI number</P><P>Forename</P><P>Surname</P><P>Date purchased car</P><P>Date purchased house</P><P>Date purchased van</P><P></P><P>I'd like to be able to pull out the earliest date between date purchased car, date purchased house and date purchased van. For example see below</P><P></P><TABLE border="1" class="jiveBorder" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 100%; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>NI num</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Forename</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Surname</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Date purchased car</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>date purchased house</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Date purchased van</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Earliest</STRONG></TH></TR><TR><TD style="padding: 2px;">111111</TD><TD style="padding: 2px;">Bob</TD><TD style="padding: 2px;">Smith</TD><TD style="padding: 2px;">01/01/2014</TD><TD style="padding: 2px;">05/05/2014</TD><TD style="padding: 2px;">01/08/2014</TD><TD style="padding: 2px;">01/01/2014</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Can this be done?</P></BODY></HTML> Thu, 07 Aug 2014 15:44:39 GMT https://community.qlik.com/t5/QlikView/Earliest-date/m-p/733927#M475140 Anonymous 2014-08-07T15:44:39Z Re: Earliest date https://community.qlik.com/t5/QlikView/Earliest-date/m-p/733928#M475141 <HTML><HEAD></HEAD><BODY><P>use the function Min(date)</P></BODY></HTML> Thu, 07 Aug 2014 15:47:33 GMT https://community.qlik.com/t5/QlikView/Earliest-date/m-p/733928#M475141 ecolomer 2014-08-07T15:47:33Z Re: Earliest date https://community.qlik.com/t5/QlikView/Earliest-date/m-p/733929#M475142 <HTML><HEAD></HEAD><BODY><P>=Date(RangeMin([Date purchased car],[date purchased house],[Date purchased van]))</P></BODY></HTML> Thu, 07 Aug 2014 15:49:06 GMT https://community.qlik.com/t5/QlikView/Earliest-date/m-p/733929#M475142 MK_QSL 2014-08-07T15:49:06Z