topic Re: unable to handle date format issues in Talend Studio

unable to handle date format issues

Anonymous — Sat, 16 Nov 2024 02:04:09 GMT

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.

Re: unable to handle date format issues

David_Beaty — Wed, 24 Jun 2020 12:18:41 GMT

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.

Re: unable to handle date format issues

Anonymous — Thu, 25 Jun 2020 07:44:59 GMT

thank you for looking into my query

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

regards.

Ankita

Re: unable to handle date format issues

David_Beaty — Thu, 09 Jul 2020 15:36:08 GMT

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.

Re: unable to handle date format issues

David_Beaty — Thu, 09 Jul 2020 15:36:08 GMT

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.

Re: unable to handle date format issues

David_Beaty — Thu, 09 Jul 2020 15:37:04 GMT

TalendDate How To Check a Date

Re: unable to handle date format issues

David_Beaty — Thu, 09 Jul 2020 15:37:04 GMT

TalendDate How To Check a Date