Dates Check

[AlteryxLearner23]

Hi,

The attached file shows a load of data, with figures on the right side from Jan-2023 to Dec-2028.

Columns I and J are "Start Date" and "Exit Date".
I want to flag any rows that have data that IS NOT zero outside of the date range.

For example,

If a building has a Start Date of 1st Dec 2023 and Exit Date of 1st May 2025, then I would want to flag this row if there are numbers other than zero either before Dec 2023 or after May 2025.

Hope that makes sense!

[Prometheus]

Quick question: Where are you looking for the numbers when you say, "then I would want to flag this row if there are numbers other than zero either before Dec 2023 or after May 2025"? Are you talking about the day value in the date being something other than "00"?