topic Re: Max Date from 3 different dates in QlikView https://community.qlik.com/t5/QlikView/Max-Date-from-3-different-dates/m-p/1083166#M931910 <HTML><HEAD></HEAD><BODY><P>Knew they'd be something - many thanks</P></BODY></HTML> Thu, 03 Mar 2016 15:36:48 GMT haymarketpaul 2016-03-03T15:36:48Z Max Date from 3 different dates https://community.qlik.com/t5/QlikView/Max-Date-from-3-different-dates/m-p/1083164#M931908 <HTML><HEAD></HEAD><BODY><P>QV11 SR4</P><P></P><P>I'm wondering if there's a clever way of finding the most recent date of 3 dates.</P><P></P><P>I have 3 different dates (DD/MM/YYYY) from 3 different sources - a user could be in 1 or more source each with an assoicated address</P><P></P><P>depending upon which date is the most recent i want to use the address associated with that source.</P><P></P><P>I could probably do this in a lengthy IF statement but am wondering if there's a better way to go about it?</P><P></P><P>Want to do in the LOAD statement - all data in same table</P><P></P><P>Any pointers would be great.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Max-Date-from-3-different-dates/m-p/1083164#M931908 haymarketpaul 2020-11-25T16:16:04Z Re: Max Date from 3 different dates https://community.qlik.com/t5/QlikView/Max-Date-from-3-different-dates/m-p/1083165#M931909 <HTML><HEAD></HEAD><BODY><P>You can use RangeMax()</P><P></P><P><STRONG>RangeMax(Date1, Date2, Date3)</STRONG></P></BODY></HTML> Thu, 03 Mar 2016 15:05:14 GMT https://community.qlik.com/t5/QlikView/Max-Date-from-3-different-dates/m-p/1083165#M931909 sunny_talwar 2016-03-03T15:05:14Z Re: Max Date from 3 different dates https://community.qlik.com/t5/QlikView/Max-Date-from-3-different-dates/m-p/1083166#M931910 <HTML><HEAD></HEAD><BODY><P>Knew they'd be something - many thanks</P></BODY></HTML> Thu, 03 Mar 2016 15:36:48 GMT https://community.qlik.com/t5/QlikView/Max-Date-from-3-different-dates/m-p/1083166#M931910 haymarketpaul 2016-03-03T15:36:48Z Re: Max Date from 3 different dates https://community.qlik.com/t5/QlikView/Max-Date-from-3-different-dates/m-p/1083167#M931911 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 03 Mar 2016 15:37:37 GMT https://community.qlik.com/t5/QlikView/Max-Date-from-3-different-dates/m-p/1083167#M931911 sunny_talwar 2016-03-03T15:37:37Z