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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date Conversion 05-JUN-2017 into 05-06-2018

How to convert String 05-JUN-2017 into date 05-06-2017 in tMap?

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

TalendDate.formatDate("dd-MM-yyyy", TalendDate.parseDateLocale("dd-MMM-yyyy", "05-JUN-2017", "EN"))

View solution in original post

3 Replies
TRF
Champion II
Champion II

TalendDate.formatDate("dd-MM-yyyy", TalendDate.parseDateLocale("dd-MMM-yyyy", "05-JUN-2017", "EN"))
Anonymous
Not applicable
Author

When i convert the error has been occured

 

String 05JUN2017 is unparsable Date @TRF

TRF
Champion II
Champion II

05JUN2017 doesn't match with the format of your initial post...

Change to

TalendDate.formatDate("dd-MM-yyyy", TalendDate.parseDateLocale("ddMMMyyyy", "05JUN2017", "EN"))