Thank you all it helps. I use DPP as I find a bit easier and usually export using jpg purely to save disk space tiff are 10 times bigger much bigger than raw file itself. But any I got the answer and know the way.
I noticed that when I do my first level edit in Canon's DPP 4.5 and save it Affinity still opens the original image. It is a bit annoying and the only way to capture those edits is to convert the image to JPG and then edit in Affinity. The problem is every conversion means loss of image quality. Is there a way around this?