Format of Date

[Subash1]

Hello all.

I am using tftpfileproperty in one of my job. It has one schema in it called mtime_string which is the date in string format like : "Tue Jan 14 13:30:09 IST 2020". Now i am using a tmap and my aim is to convert this "Tue Jan 14 13:30:09 IST 2020" into a date format of "yyyyMMdd" only.

How to do it ...can anyone please suggest..?

Many Many thanks

[TRF · Accepted solution]

Try this:

TalendDate.formatDate("yyyyMMdd", TalendDate.parseDate("EEE MMM dd HH:mm:ss z yyyy", row1yourDateField))

This should work.

[Subash1]

Hii TRF,

Thanks so much.It worked for me