topic Re: Convert Date format from YYYY/MM/DD to MMM/DD in Talend Studio

Convert Date format from YYYY/MM/DD to MMM/DD

Anonymous — Fri, 11 Jan 2019 10:22:46 GMT

HI,

I am trying to convert a date format from yyyy/mm/dd to MMM-YY. E.g., if the date in the input excel is 2019/01/01 then I want the output as JAN-19 and I have used TalendDate.formatDate("MMM-yy",row28.Start_Date) in the Variable and StringHandling.UPCASE(Var.var1) in the expression .

The input file is excel and the Type is Date "YYYY/mm/DD". For the output format I am changing it to String in variable and string in output excel. I am getting null pointer exceptions about Dateformat so I tried to add row28.Start_Date==null?null:TalendDate.formatDate("MMM-yy",row28.Start_Date) .

It is running without errors but now it is returning only blank for that oarticular column.

any help will be greatly appreciated.. Thanks

Re: Convert Date format from YYYY/MM/DD to MMM/DD

akumar2301 — Fri, 11 Jan 2019 11:07:46 GMT

Ideally while reading excel , in tFileInputExcel schema you could define yourcolumn as Date and change the date pattern to MMM-yy . It should work.

Re: Convert Date format from YYYY/MM/DD to MMM/DD

Anonymous — Fri, 11 Jan 2019 11:12:01 GMT

Hi akumar2305,

Thanks for the reply.

I would be using that column to map other columns in the output so I dont think I can change the dateformat because it will affect other column data.

Re: Convert Date format from YYYY/MM/DD to MMM/DD

vapukov — Fri, 11 Jan 2019 11:27:29 GMT

possible it some mistake somewhere, because it work as expected:

[statistics] connecting to socket on port 3784
[statistics] connected
.----------.
|tLogRow_1 |
|=--------=|
|Start_Date|
|=--------=|
|Jan-19    |
|null      |
'----------'

[statistics] disconnected

Re: Convert Date format from YYYY/MM/DD to MMM/DD

akumar2301 — Fri, 11 Jan 2019 11:28:35 GMT

Try to put tLogRow and check if you are able to read start_date correctly.

I think it is coming as NULL or "" to your expression.

Please share you input sample and design . It must be very small issue.

Re: Convert Date format from YYYY/MM/DD to MMM/DD

Anonymous — Fri, 11 Jan 2019 12:27:27 GMT

Hi,

You were right.. My bad. The input file value was actually blank for the record I was checking. I passed a dummy date and it processed fine. Thank you..