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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

String to Date conversion always gives 20170101

Hi Team,

 

I am trying to convert a string(20170404) to a date of format YYYYMMDD, since my target is a date format.

 

I tried both tmap and tconverttype both gave me 20170101. Please advise what I might be doing wrong!

0683p000009Lv5r.png

0683p000009Lv61.png

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

Change the date format mask:

TalendDate.parseDate("yyyyMMdd",row1.date_val) 

View solution in original post

1 Reply
TRF
Champion II
Champion II

Change the date format mask:

TalendDate.parseDate("yyyyMMdd",row1.date_val)