I am looking to process the following
- Read Excel into Data Table
- Split Data Table dependant on criteria
- Write these into a Table
- Add Table into Outlook email
- Send
The process is all working, the issue I am having is that the date when taken out of excel is being converted to data serial and I cannot find a way to a) prevent this from happening or b) convert it back into a date
The dates look like this in the Excel - I dont have control over how the formatting arrives
And this how the email looks when it arrives
Am using a ReadRange to get the data into UiPath
Any ideas on how to correct this would be appreciated
thanks