How to get max date

[rmartinez4]

Hi All, 

I have set of columns from each file I used for a device with a set of dates but I need a new column with the Max date only across the 4 columns.

Device Name           Sun's Date       Mars  Date       Earth Date       Venus Date         Max Date  

Test1                       2022-10-02       2022-10-03      2022-10-06      2022-10-01        2022-10-06 

Test2                       2022-10-02       2022-10-07      2022-10-06      2022-10-01        2022-10-07 

Thank you,

[Felipe_Ribeir0]

Hi @rmartinez4 

The simplest way is to use the max function in formula tool. Max( Sun's Date,       Mars  Date,       Earth Date,       Venus Date)  

Check the attached example

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[Jonathan-Sherman]

Hi @rmartinez4,

You would be best transposing the data to find the max value and joining it back on to the original data set.

I've attached an example for you to take a look into!

Kind regards,

Jonathan

[Jonathan-Sherman · Accepted solution]

Transposing the data ensures all columns are tested, including if others are added in the future

[binuacs]

@rmartinez4 One way of doing this