How to get max date

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,

Workflow

Time Series

Accepted answers

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

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.

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

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

@rmartinez4 One way of doing this