Dates Check - Help
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AlteryxLearner23
7 - Meteor
‎07-14-2023
05:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎07-14-2023
06:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try this
 
‎07-14-2023
07:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Christina_H
14 - Magnetar
‎07-14-2023
07:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator