Hai All,
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?
Thank you.
Hi Visu,
You can keep the date format as DD/MM/YYYY in the flatfile. Now in the transfer rules -> Datasource/Trans.Structure tab -> Goto the date field and if your scroll to the right you would find a column "Conversion" -> select "PDATE" as the conversion. You can then go ahead and load.
Bye
Dinesh
Add a comment