date extracting issue while reading from tFileInputexcel

[Anonymous]

As per requirement i need to read and keep the date in string format only. (MM-dd-yyyy)

input  "7/25/2018" i am getting in this format but when data pass through tMap I am getting "7/25/18" in this format.

let me know how to get "07/25/2018" in this format.

[manodwhb]

@sandeephakki ,check the below way in tmap.

[manodwhb]

@sandeephakki ,check the below link also.

https://community.talend.com/t5/Design-and-Development/Capture-Invalid-Date-type-Values-in-tMap-reje...

[Anonymous]

Hi manodwhb,

It's not working. My input in .xlsx sheet is "7/25/2018" when talend reads it i am getting "7/25/18", if i try to convert in all the forms i am getting "7/25/0018".

Ultimately i need "7/25/2018" or "7-25-2018" in this format. year shouldn't crop or append 00.

[manodwhb]

@sandeephakki ,it could be source data issue,please check with source team.