Max Collect latest date based on 2 criteria

Brandon22

Hello,

I am trying to get the latest date to populate by using MAX and COLLECT based off of the Zone being Ambient, and the Floors checkbox being checked.

This is what I currently have: =MAX(COLLECT({When}, {Where}, Zone@row, {Floors}, =1))

Here is where I am pulling the data from:

And here is where I am hoping to have the date populate:

Thank you!

Paul Newcome

Make sure both columns are set as date type columns.