How do I create another column in the same table that takes the max date from 3 other date columns

[jcharles]

I would like to know how to create a new column called "ClosedStatusDate" in the table below and then the data in this column should be the max date out of the 3 columns called "Date Finalised", "Date Closed" and "Date Converted" (Whichever has the last date). If there is no date then "ClosedStatusDate" will be blank.

Please help? Should be fairly easy but I'm a beginner. Thank you

The table looks like this:

Case ID	Date Reported	Date Finalised	Date Closed	Date Converted
12345	29/10/2009	31/11/2013	02/02/2011
12346	23/05/2012	04/02/2014
12347	01/03/2013		14/06/2013
12348	22/01/2014			24/01/2014
12349	31/01/2014

[#2 · Accepted solution]

I would use the rangemax() function

LOAD ..., Rangemax(Field1, Field2, Field3) as xxx

FROM ...

Fabrice

[jcharles]

I really appreciate the super quick response. It works !!!! Thank you.

[#4]

Excellent,

Tag the answer as correct then

Fabrice

[#5]

PFA

[jcharles]

Thank you, that also works