This content has been marked as final. Show 2 replies
I have a data set whch has "DATETIME of Count field"
I would like to look in the "Time of Movement" field and find the next time whcih grater then the "DATETIME of Count field" AND THE GREATEST TIME before
For the Number = AF65VEO"
The time of the movement after the "datetime of count" field =20/11/2018 16:30:00
and the time before is
I would like to identify this for a large amounbt of records
is it possible to get a simple wortksheet with
Number Name before Count Name After count
AF65VEO Ste Uni