Problem
*.AVI files ignore the RIFF:DateTimeOriginal and instead use the System:FileModifyDate in the XMP sidecar file for the XMP-xmp:CreateDate and XMP-photoshop:DateCreated
My Fixes
Inspect dates:
exiftool -groupNames1 -short -duplicates -time:all -extension AVI -recurse .
exiftool -groupNames1 -short -duplicates -time:all --System:all -extension AVI -srcFile %d%f.xmp -r .
Prevent the error with:
exiftool "-FileModifyDate<DateTimeOriginal" -extension AVI -recurse . -verbose
Copy over the good date tags after deleting potentially bad ones:
exiftool -extension AVI -TagsFromFile @ -XMP-xmp:CreateDate= -XMP-photoshop:DateCreated= -allDates -srcFile %d%f.xmp -recurse . -verbose