Could you please tell me the version of your Excel?
File>Account>About Excel
Could you successfully export to XML without adding the date column?
How did you export to XML?
Did you follow the steps in “Export XML data”?
Do you have a XML Map?
Please refer to “Export Excel to XML Tutorial”, it may be helpful for you.
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.
Besides, is there any error message when failing to export to XML?
If there is, please give the screenshot.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.