Change date format (Fri Jan 06 00:00:00 GMT+01:00 2019) into dd/MM/yyyy (Error: the method paseDateLocale(Strin,String,Strin) in the type TalenDate is not applicable for the arfuments(String,Date,String)

[Moro]

Hi all -

I looked at the date format conversion and tried the following in order to convert this date format:

Fri Jan 06 00:00:00 GMT+01:00 2019 into MM/dd/yyy or dd/MM/yyyy :

TalendDate.parseDateLocale("EEE MMM dd HH:mm:ss zzzzzzzzz yyyy",row1.date,"EN") 

I got the Error:

 

Both input and output type are set as "date" in tMap.

I managed to convert other formats but this GMT+ type I dont manage at the moment.

Thank you for any suggestion!!

[Anonymous]

This looks like a data type issue. Your row1.date column is a Date and not a String. You shouldn't need to use this method at all. The Date class (the type you have) is essentially a number that represents a date. As such, you simply need to format it to a String if you want to see it in a report or in a text file. If you are sending it to a DB, you do not need to change it.