Convert CSV-Date in new format

Two Stars

Convert CSV-Date in new format

Hi,

 

i have a CSV File with a String information with following pattern dd.MM.yyyy i need to convert it to yyyy-MM-dd to import it into salesforce but i am not able to convert it. Could you please help me with my issue?

 

Thanks an best regards

 

Nuglo

Four Stars

Re: Convert CSV-Date in new format

You can use tFileInput or similar component depending on type of your file. Map the contents or input data elements to output (Salesforce component) using tMap. You can use formatDate which should return a date string which corresponds to the format specified.