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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Romanesku
Contributor III
Contributor III

TalendDate.parseDate: Unparseable date only for "May"

Hi,

I have problem with parsing date from csv file. My function tMap look like

 

TalendDate.parseDate("[dd/MMM/yyyy:HH:mm:ss.SSS]",row7.fulltime )

 

when this job runs in mounts ago: April, March with values like [01/Apr/2018:00:00:09.236]

everything works well, but from May I have problem, value [01/May/2018:00:00:09.236] return an exception

 

Exception in component tMap_1 (TestMayError)

java.lang.RuntimeException: java.text.ParseException: Unparseable date: "[01/May/2018:00:00:09.236]"

 

Do you have idea what should be wrong? I think this should be a localization, but I can not find how to confirm or change it.

 

Thank you.

 

Roman 

Labels (4)
1 Solution

Accepted Solutions
Romanesku
Contributor III
Contributor III
Author

Hi Manohar,

 

thank you, I found where was the problem. On my PC is location Slovakia and the formats as well Slovak.

When I change the formats to the English for Europe, it start to work.

 

regards,

Roman

  

View solution in original post

2 Replies
manodwhb
Champion II
Champion II

@Romanesku,check the below way i could able to convert.

 

0683p000009LxAV.png0683p000009LxJH.png

Romanesku
Contributor III
Contributor III
Author

Hi Manohar,

 

thank you, I found where was the problem. On my PC is location Slovakia and the formats as well Slovak.

When I change the formats to the English for Europe, it start to work.

 

regards,

Roman