Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Subash1
Contributor
Contributor

Format of Date

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

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

Try this:

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

This should work.

 

View solution in original post

2 Replies
TRF
Champion II
Champion II

Try this:

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

This should work.

 

Subash1
Contributor
Contributor
Author

Hii TRF,

Thanks so much.It worked for me