I have a dataset in Oracle. This feature class has a text-field with the following information in:
3/7/2017 1:34 PM: Object picked up by User 2
2/27/2017 4:50 PM: Object closed by User 3
2/21/2017 4:49 PM: Object picked up by User 2
2/20/2017 2:39 PM: New object by User 1
Where date, time and User are variables.
So the next information is also in the attribute table, but at another object
But I can also have the next information in the attribute:
3/7/2018 1:34 PM: Object picked up by User 6
2/29/2018 4:50 PM: Object closed by User 4
1/27/2018 4:49 PM: Object picked up by User 9
1/18/2018 2:39 PM: New object by User 8
I would like to filter just the date where User 2/ 9 picked up the object for he first time.
In the case above 2/21/2017 and 1/27/2018.