Hi, thank you very much for your kind reply!
I am new with Python, I think that it could be pretty easy....
Well, below is an example of the workflow I need to accomplish: I have a point feature class with all data I need. It includes traps with their regular inspections details (all stored in one feature, I don't have a point dataset and a related table with inspection data and I don't know if it would make a problem for my next steps when I want to publish and update my dashboard app online. Your advice would be nice for this, too). Anyway, my problem is that I want to fill the timerange field with the date difference between the "last" and "previous" inspection dates per trapcode. For example for trap1 I must fill in the timerange field of second record with 27/723-5/7/23 = 22 days, the third srecord with 1/8/23-27/7/23=4 days atc
I want to find a workflow to do that automatically, but I am confused because the date data are stored in the same field and I want to do that per trap code not just erase the one record from the previous one. (I don't know, it will work if I sort them out first?).... I added a second field and name it "previous_date" to complete the arcade diff() expression but since I did it by hand I am not sure if it is the most appropriate way because in the future there will be lot of records to update!
Any comment would be very helpful!
Thanks in advance!