max collect where the potential dates are in several columns

System

This discussion was created from comments split from: Most recent date for specific asset.

Valerie_WPA

Is there a way to do a max collect where the potential dates are in several columns?

I have a similar situation where I have a column for each month and want to be able to pull the last PM date for an asset that has a 3 month PM Interval.

I also have a column I have to include in the parameters where I mark which type of PM it is.

IE: Full vs Running. (I use a checkbox column for each of these options)

Paul Newcome

@Valerie_WPA Are you able to provide a screenshot for reference?