This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.
Hello,
This is something you would want to correct in the source. In case if that option is not possible you always have a choice to use Power Query. You will need to convert your type Date into text and then replace it with blank.