unable to handle date format issues

[Anonymous]

hi,

i have 2 date format in my excel input file one is date with time stamp that is "EEE MMM dd hh:mm:ss Z yyyy" and other is in mm/dd/yy  i have to convert both of the date formats in one format as MM/dd/yyyy

can any one could help me out with this please!

regards

Ankita.

[David_Beaty]

Hi

You should bring the value in as a String and convert it in Talend in a tJavaRow. I normally have a context variable with a delimited list of formats to try and loop through those.

[Anonymous]

hi

thank you for looking into my query

i have been using TalendDate.ParseDate for conversion but it is not working.

regards.

Ankita

[David_Beaty]

Hi,

You should probably start off with a TalendDate.isDate({string date},{date format}) method first. and then only convert it if that is true.

[David_Beaty]

Hi,

You should probably start off with a TalendDate.isDate({string date},{date format}) method first. and then only convert it if that is true.

[David_Beaty]

TalendDate How To Check a Date 

[David_Beaty]

TalendDate How To Check a Date