One Star

issues with date format

hii all,
I am using talend MDM v5.2.2 with java
i am trying to fetch data(date column) from excel file.
date format is "DD/MM/YYYY". I converted it to" YYYY-MM-DD" using tjavarow. Now i want to insert this record in a table on MDM server.
texcelFile--> tjavarow-->tlogrow1-->tmap-->tlogrow2-->tmdmoutput
format is properly shown in tjavarow but in tlogrow1 it changes
eg:
Destination Date : 2013-07-08
2013-07-189|MY|MY-02|W
Destination Date : 2013-07-09
2013-07-190|MY|MY-02|H
Destination Date : 2013-07-10
2013-07-191|MY|MY-02|W
Destination Date : 2013-07-11
2013-07-192|MY|MY-02|W
Destination Date : 2013-07-12
2013-07-193|MY|MY-02|W
Destination Date : 2013-07-13
2013-07-194|MY|MY-02|W
Destination Date : 2013-07-14
2013-07-195|MY|MY-02|W
Destination Date : 2013-07-15
2013-07-196|MY|MY-02|W
Destination Date : 2013-07-16
10000013|2013-01-15|||W|
Can somebody help me out

1 REPLY
One Star

Re: issues with date format

Hi,
Check the Pattern in the schema of the input component that reads the Excel file. If you set the proper format there, you don't need to convert strings. The date will be loaded a Date object.
Can you send some screenshots, specially the input schema window? Also some sample of the input data will help you get some answers.
Regards,
Thiago