Sorry.. perhaps I was not clear.. changing the date has nothing to do with the problem.
Here is the method step by step.
1 Boot to recovery.
You use Option + Command + R
I usually just hold down Option key when you hear the start chime from off.. and all the boot devices will show.. including Recovery.
https://recoverit.wondershare.com/mac-data-recovery/boot-into-recovery-mac.html?gclid=EAIaIQobChMIzNLoyv665QIVyB-tBh1ZLQ50EAAYASAAEgIhlPD_BwE&gclid=Cj0KCQjwrIf3BRD1ARIsAMuugNt971CJmhKemBRN1GOtEDyRZ5FI4-qw6ymWOO82wIjnGWJ6GwNuU6MaAvMdEALw_wcB
2 Start Time Machine which might be called Setup Assistant.. not sure lately as names have changed.
It will allow you to access the Time Capsule and try and find the backup. If it opens.. then you are presented with date you wish to restore to.. This is the date I am tell you use.
Please read a much earlier post I did on using both Recovery and Migration tools. It is a long thread so please do spend the time to read the whole thing. Even if somewhat out of date it should help you.
https://discussions.apple.com/thread/7236090
There is a picture from this with the title above it..
Pick the date. Skip to ones before the failure.. maybe a few days.
3 If you cannot open the Time Machine backup here you will need to rename it to sparsebundle from backupbundle. All versions of Mac OS TM used Sparsebundle until Catalina when it changed.. Apple has given no explanation of why.
4 Then restore this version of the boot drive to a different disk. I suggested a USB drive plugged into the computer so you don't mess up the current install.
If the above doesn't work at all, then delete the inprogress file from inside the backup.
https://www.fireebok.com/resource/three-ways-to-remove-inprogress-time-machine-backup.html
In the same post I did there is a picture showing the inprogess file you need to delete.

This file will often block the Time Machine backup being used.
TM cannot see the file at moment.
TM in Sierra cannot open Catalina version TM file..
But in Finder you should be able to open it after you change the name.
And remember to archive first.. before you start messing around otherwise you could damage the TM backup beyond recognition.