Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dates Check - Help

AlteryxLearner23
7 - Meteor

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!

3 REPLIES 3
Christina_H
14 - Magnetar

Try this

Capture.PNG

 

AlteryxLearner23
7 - Meteor

Thanks @Christina_H 

 

Could you attach the script if possible?

Christina_H
14 - Magnetar

Oh sorry, reattached your data instead of the workflow!

Labels
Top Solution Authors