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: 
Anonymous
Not applicable

How to convert string to date


How to convert string whose value is "29-JUN-2018" (including double parenthesis in its value) to date format? 
The expected format is "yyyy-MM-dd'T'hh:mm:ss.SSS"

Labels (2)
2 Replies
fdenis
Master
Master

first tmap split your string in 3 parts
second Tmap change Jun to 06
third Tmap convert 20180629 to dat then format this Date
TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("yyyyMMdd", 20180629 ))
Anonymous
Not applicable
Author

0683p000009Lym2.png0683p000009Lyvb.png0683p000009Lyvg.png0683p000009Lyk0.png