[resolved] String to date conversion Unparsable date:""

[Anonymous]

Hi,
I have string value of date "yyyy-MM-dd'T'hh:mm:ss'.'SSS'+'SSSS" (guessed pattern for 2015-11-18T06:24:26.000+0000 value) and i want to convert into date with  pattern "dd/MM/yyyy HH:mm:ss" in tmap.
Give me the expersion to be used in tmap
I tried [font=Verdana, Helvetica, Arial, sans-serif]TalendDate.parseDate("dd/MM/yyyy HH:mm:ss",row4.LastViewedDate)  in tmap[/font]
[font=Verdana, Helvetica, Arial, sans-serif]I'm getting errors like[/font]
[font=Verdana, Helvetica, Arial, sans-serif] Unparseable date : ""[/font]
[font=Verdana, Helvetica, Arial, sans-serif]and[/font]
[font=Verdana, Helvetica, Arial, sans-serif]Unparseable date: "2016-05-04T12:39:46."
[/font]
[font=Verdana, Helvetica, Arial, sans-serif]thanks in advance..[/font]
[font=Verdana, Helvetica, Arial, sans-serif]VK[/font]

[Anonymous]

Hi,
Could you please show us your tMap editor screenshot?

Best regards
Sabrina

[vapukov · Accepted solution]

TalendDate.parseDate( "yyyy-MM-dd'T'HH:mm:ss.SSSZ",row3.newColumn) 
must help

[Anonymous]

Thank you so much.... It works....