I am getting Data from source in a flat file. There is a column D_DATE which will have data in the format DDMMYYYY. I need to convert it to YYYY-MM-DD. I used StringToDate function but in vain.
The Code i used are
Code: Select all
StringToDate(DSLink1.D_DATE,"%yyyy%mm%dd")
Code: Select all
StringToDate(DSLink1.D_DATE,"yyyy-mm-dd")
Can somebody let me know where i am going wrong.
Thanks for your help in advance.