Excellent suggestion, thanks for that. Have actually put this in place and it seems to be working exactly as expected. My only regret is that the Certification upload tool doesn't allow you to manually set the expiry dates so I've now got to manually adjust hundreds of records, but I suspected this would be the case and it's still better than what I had before.
Thanks for your help, much appreciated.
Dan