Max Date from 3 different dates

[haymarketpaul]

QV11 SR4

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.

[sunny_talwar · Accepted solution]

You can use RangeMax()

RangeMax(Date1, Date2, Date3)

[haymarketpaul]

Knew they'd be something - many thanks

[sunny_talwar]