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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Cannot convert string to date-unparseable date

I'm getting an error converting a string to a date.  It tells me that its an unparseable date.  The input date looks like this  

 

2/19/2019 17:23.  I'm trying to convert it to a date without the time.

Labels (2)
1 Reply
manodwhb
Champion II
Champion II

@gfred ,for this kind of data first you need to as seconds portion to the source and need to convert,please check the below screen shoot.

TalendDate.parseDate("MM/dd/yyyy HH:mm:ss",Var.var1)

0683p000009M4iy.png

 

otherwise with same data you wan to get only "dd-MM-yyyy" portion can be done with below way also.

TalendDate.parseDate("MM/dd/yyyy HH:mm",row1.col)

0683p000009M4j3.png