topic Re: NullPointer Exception with TalendDate.FormatDate() in Talend Studio

NullPointer Exception with TalendDate.FormatDate()

HMolitor — Thu, 15 Oct 2020 10:08:38 GMT

Hello,

my source is an excel sheet where I have a column which is obviously a date, so in the schema in talend I defined that column as date.

In tMap I want to convert it to a string so I do --> TalendDate.formatDate("dd-MM-yyyy", row1.mydate) and get the following error :

java.lang.NullPointerException

at java.util.Calendar.setTime(Calendar.java:1770)

at java.text.SimpleDateFormat.format(SimpleDateFormat.java:943)

at java.text.SimpleDateFormat.format(SimpleDateFormat.java:936)

at java.text.DateFormat.format(DateFormat.java:345)

at routines.TalendDate.formatDate(TalendDate.java:129)

I tried several date patterns but it makes no difference.

Thanks in advance!

manodwhb — Thu, 15 Oct 2020 10:45:07 GMT

@Hendrik Molitor , can you try to use the below one.

row1.mydate==null?null:TalendDate.formatDate("dd-MM-yyyy", row1.mydate)

Thanks,

Manohar

HMolitor — Thu, 15 Oct 2020 11:00:46 GMT

Oh...i thought I excluded null value rows but obviously I didn`t...so this helps a lot 🙂

Thanks!!!

manodwhb — Thu, 15 Oct 2020 11:20:47 GMT

@Hendrik Molitor , you can mark the replay as Answer and like it, the one which helped you . So that it will help to others.

Thanks,

Manohar