Discussion board where members can get started with QlikView.
I'm wondering if there's a clever way of finding the most recent date of 3 dates.
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
depending upon which date is the most recent i want to use the address associated with that source.
I could probably do this in a lengthy IF statement but am wondering if there's a better way to go about it?
Want to do in the LOAD statement - all data in same table
Any pointers would be great.
You can use RangeMax()
RangeMax(Date1, Date2, Date3)
View solution in original post
Knew they'd be something - many thanks