Dates Check - Help

[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!

[Christina_H]

Try this

 

[AlteryxLearner23]

Thanks @Christina_H 

Could you attach the script if possible?

[Christina_H]

Oh sorry, reattached your data instead of the workflow!