Hi Guys!
Im having trouble figuring out a way to compare two separate number ranges, I'm stumped and do not know where to begin.
I work for a farming company and we harvest strawberries. Strawberries are a row crop and each row is represented by a number 1,2,3 etc.
we keep track of our harvest via a manual harvest log ex:
| date | rows harvested |
| 2/1/23 | 1-150 |
Throughout the growing season certain materials are applied to strawberry rows to aid in production but once applied these rows cannot be harvested until a certain time period has elapsed. We track these rows in a similar manner as we do the harvested rows.. a basic table:
| date | rows | re entry (harvest)interval |
| 1/29/23 | 1-150 | 24 hours |
In this case rows 1-150 were treated w/ a material which prevents those rows from being harvested for 24 hours which is why those rows were harvested on 2/1/23 well after the required 24 hour waiting period
Ok.. hope I havent lost ya'll ! I would like to create an app where treated rows are stored and upon the beginningn of a harvest date if rows that are to be harvested fall within the treated rows ... I get an alert.
HOW CAN I ASK THE QUESTION: Do the rows that are set to be harvested today fall within the treated rows which cannot be harvested? if so= ERROR.
LinkedIn
Twitter
