You can do it in GSAK. I have use this sql line for it . selet the tools/sql mananger and run the query below
It can only work with your current database and you have to have appropriate logs in the database. geting all logs on you fins will take a lone time so you might what to do some selection of what you what to update ie ignore all powertrail etc because they will never have long last found date. The second query is the same with user flag set requirement to make the chck eays
A warning is that the query ignore other fins on the same day so if you have found it with somone else it will work but you have to manualy check for that.
And if logs are missing the result will be incorrect. A found log before yours is required to be in the databse for a cache to appear in the list
select *, (julianday(MyDate) - julianday(LastDate)) as diff from(SELECT c.Code AS Cache, c.Name AS Name, c.FoundByMeDate AS MyDate, COALESCE (( SELECT l2.lDate FROM Logs l2 WHERE l2.lParent = c.Code AND l2.lDate < c.FoundByMeDate AND (l2.lType = 'Found it' or l2.lType = 'Webcam Photo Taken') ORDER by l2.lDate DESC LIMIT 1 ), c.FoundByMeDate ) AS LastDate FROM Caches c WHERE c.Found ) where diff >0 order by diff desc
select *, (julianday(MyDate) - julianday(LastDate)) as diff from(SELECT c.Code AS Cache, c.Name AS Name,c.county as Kommun, c.FoundByMeDate AS MyDate, COALESCE (( SELECT l2.lDate FROM Logs l2 WHERE l2.lParent = c.Code AND l2.lDate < c.FoundByMeDate AND (l2.lType = 'Found it' or l2.lType = 'Webcam Photo Taken') ORDER by l2.lDate DESC LIMIT 1 ), c.FoundByMeDate ) AS LastDate FROM Caches c WHERE c.Found and c.userflag AND date(MyDate, '1 days') > LastDate ) where diff >0
