probably a simple question. I am downloading data from an ODS. I have dates int he format 8/3/2006. I need to upload this data after modifications as a flat file. But the date format in flat file needs to be in 20060803 format.
I am saving this data to excel.
How can I convert this automatically?