The question’s in the title, really. I’d imagine that
LastModifiedDate
for a deleted record would be the date it was deleted. But, anecdotal evidence from users seems to dispute this…I’ve queried some deleted records using
IsDeleted = true
andALL ROWS
. All of those deleted records have last modified date of 2017-07-20. There are no records where IsDeleted is false.Anecdotal evidence from users has that there were some records for that object on 2017-07-21.
So, am I wrong about
LastModifiedDate
for deleted records? Are the users wrong? Is there some other explanation?
Answer
Thanks to @AdrianLarson for the suggestion, but SystemModStamp got me the same answer as LastModifiedDate.
The user with the anecdote has just confessed to being confused and misreporting the situation on 2017-07-21.
Which makes me think that LastModifiedDate is going to be the date of deletion. It would be a bit crazy to be anything else. I’ll leave this here for a little while in case someone does know better and/or has references confirming that. Otherwise, I guess that this is the answer.
Attribution
Source : Link , Question Author : Aidan , Answer Author : Aidan