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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
abhi90
Creator II
Creator II

Parse to MM/dd/yyyy format Date from dd-Mon-yy Format and Validation

Hi All,

 

I have a scenario. My Source Data Date is coming in dd-Mon-yy. Example 9-Jun-17. I want to convert it into MM/dd/yyyy. Final Desired Output will be 6/9/2017. Using TalendDate.parseDate("MM/dd/yyyy",row1.START_DATE). But getting Unparseable Date error. Also want to create a Variable Port where it will check for format..In the Variable Port Condition is like this

TalendDate.isDate(row1.START_DATE,"dd-MMM-yy",true). But it is also not working. Can anyone please help

@vboppudi@rhall@TRF@TRF@manodwhb

Labels (2)
10 Replies
manodwhb
Champion II
Champion II

@abhi90,you can accept solution as many,since all are right0683p000009MEvb.png