Pull Last Date from 4 Different Date Columns

Question

I have four different date columns. They won't all be populated, but I'm trying to add a new column to the dataset that will look at those four date fields to assess the values in those columns (if more than 1) to determine what is the last date.

Is there a formula I could create to pull that last date value into a new column?

rsbin · Accepted Answer

mattross19 ,
Please see if this works for you.&nbsp; Create a new Calculated Column:
MaxDate = MAX([4], ( MAX( [3], ( MAX( [1], [2] )))))
1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MaxDate

Tuesday, February 1, 2022
Tuesday, February 15, 2022
Monday, March 14, 2022
Sunday, April 10, 2022
4/10/2022 12:00:00 AM

Tuesday, March 1, 2022
&nbsp;
Friday, July 1, 2022
Wednesday, June 1, 2022
7/1/2022 12:00:00 AM

Regards,
&nbsp;

Forum Discussion

Pull Last Date from 4 Different Date Columns

1 Reply

Related content

Custom column pulling from different tables

Different schema into different destination

How to add two different calculated columns of two different table

1. How to add two different calculated columns of two different table

Power BI pulling in all Excel columns

Tuesday, February 1, 2022	Tuesday, February 15, 2022	Monday, March 14, 2022	Sunday, April 10, 2022	4/10/2022 12:00:00 AM
Tuesday, March 1, 2022		Friday, July 1, 2022	Wednesday, June 1, 2022	7/1/2022 12:00:00 AM