Identifying Max Date

[christinachau22]

Hello!

Wondering if there is a way to get max end date while ignoring a certain date.

Say I have the following dates:

• 2024-01-01
• 2024-03-01
• 2025-06-12
• 2050-05-24
• [null]

In my summarize tool, it's pulling 2050-05-24 as the max end date, but I really need 2025-06-12 as the date.

[DataNath]

Hey @christinachau22, you'd need to implement some sort of logic to filter out unwanted values. Do you have anything in mind you could use so that your data only has legitimate dates you want to find the max of?

[christinachau22]

Hello! Thanks for your help! I went with a different approach instead.