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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Convert a String to a Date

In my Tmap I am trying to map a String value over to a date. My data coming in looks like 2016-09-01T10:53:24. I need to remove the T and keep all other date time info there.

 

I tried to just so a row1.DateTimeModified.replace("T"," ") but that didn't work.

Labels (2)
2 Replies
vboppudi
Partner - Creator III
Partner - Creator III

Please try below.

 

0683p000009LwAT.png0683p000009Lvqe.png

 

Regards,

ThWabi
Creator II
Creator II

Hi shawnm,

convert your modified String to a Date using 

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss", row1.DateTimeModified.replace("T", " "))

 Best regards,

Thomas