Identifying Max Date

Question

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.

christinachau22 · Answer

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

DataNath · Answer

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?