Forum Discussion

mattross19's avatar
mattross19
Regular Visitor
4 years ago
Solved

Pull Last Date from 4 Different Date Columns

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 m...
Need Help
  • rsbin's avatar
    rsbin
    4 years ago

    mattross19 ,

    Please see if this works for you.  Create a new Calculated Column:

    MaxDate = MAX([4], ( MAX( [3], ( MAX( [1], [2] )))))

    1                                     2                                       3                                  4                                        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   Friday, July 1, 2022 Wednesday, June 1, 2022 7/1/2022 12:00:00 AM

    Regards,

     

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
4 years ago

mattross19 ,

Please see if this works for you.  Create a new Calculated Column:

MaxDate = MAX([4], ( MAX( [3], ( MAX( [1], [2] )))))

1                                     2                                       3                                  4                                        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   Friday, July 1, 2022 Wednesday, June 1, 2022 7/1/2022 12:00:00 AM

Regards,