Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
hi
thank you for looking into my query
i have been using TalendDate.ParseDate for conversion but it is not working.
regards.
Ankita
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.
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.